How to check access path of external database extension

How to check access path of external database extension

  

Hi,

My external database is oracle.

I wonder is there any way to I can check the access path when I do a search function on external database.


I want to check access path because I want to make sure that the indexs have been used. 


Thank you



Hi Chaiwat,

The platform doesn't supply any feature for doing this. If it's an on-premise installation, or if you have access to the database in the cloud, you can perhaps use Oracle profiling tools (I'm not familiar with Oracle, but MSSQL has a profiler that allows to see the actual queries and the query plan).