Any similar way to query all the tables with their information via sys tables ?

I am new to outsystems and I am tasked to optimized series of SQL queries using extension tables from our client but the problem is we are not authorized to create indexes for tables that we are using. So the approached we want to do is to create the index via sql query and use it on the query also, but we can not check if the index is created successfully or working.

Any query for outsystems that are similar to this query?


SELECT A.* FROM ALL_TAB_COLS A;


Thank you very much!

It doesn't sound like your issue is about OutSystems at all. OutSystems will not give you any insights into an external database to which you lack access permissions.

What you need is the proper access permissions to the external database so you can, at least, execute a query without going through OutSystems and see its execution plan.