XREF not working

Posted by kanchansharma23 on 04-Sep-2014 12:31

Hi All,

I am using dataserver to connect to oracle DB and business logic is in progress 4GL.
When I am trying to compile any file using xref to check if correct indexes are used or not, it is compiling and creating xref file but index information is not exist for queries.

Please help me out if someone has any clue.


All Replies

Posted by TheMadDBA on 04-Sep-2014 12:58

XREF isn't going to tell you anything for dataserver tables. Oracle decides how to execute the query at execution time and not compile time.

There are tools to show how queries are being executed on the Oracle side of the fence. You will have to use one of those to debug how well the code is performing.

Also reading up on the Oracle CBO (Cost Based Optimizer) would be a good idea.

This thread is closed