ADM2: How to see the used index after "openQuery" of a SDO?

[moveIT]

I need to find out which index was used after "llOK = SUPER()." in function "openQuery" of a SDO! Can anyone help me?

 

[Lee Curzon]

I reckon you may be able to use the fiollowing startup parameters - but I think you may have to configure your session so it is local first.


KB 21216
Title: "Diagnose 4GL Query Problems: Use Parameters -zqil and -zqilv"

http://tinyurl.com/d49ep

http://www.geocities.com/ResearchTriangle/3737/dlc/zqil.html


If you know what your query is at run-time (which you can find out by displaying the query string before you open it), simply copy the query to a blank .p and compile that with the XREF option.


HTH