XREF not working - Forum - OpenEdge Development - Progress Community
 Forum

XREF not working

  • 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.

    Thanks
    Kanchan
  • 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.