Resolved Index on Dynamic Queries

[Rajat Sharma]

Hi everyone, hope you all are well.

I have been trying to conclude that is it possible to check index on a dynamic query like we have XREF for static queries?

Please suggest.

Regards,
Rajat.

 

[Rob Fitzpatrick]

COMPILE XREF doesn't give you any info on dynamic queries, as you may already be aware. But you can use the QRYINFO log entry type to get some run-time information about the query; records returned, etc.

This is documented in the Debugging and Troubleshooting manual under log entry types.

 

[oli]

You can also take a look at the INDEX-INFORMATION attribute of (dynamic) query.

 

[Rajat Sharma]

Thanks Rob, oli,

I have got the answer !!

Regards,
Rajat.