Question Index Bracketing

[Rajat Sharma]

Hi everyone, hope you all are well.

Every time I write query, I am curious to know that on how many records progress creates bracket (In index entries data structure). Apparently, it’s important to know because number of records get bracted could be different from retrieved. Is there any PROMON utility or something similar that we could use for the same?

Please Suggest.

Regards,
Rajat.

 

[Rob Fitzpatrick]

Look into log entry types, documented in the Debugging and Troubleshooting manual. They can be invoked via the -logentrytypes client startup parameter or the LOG-MANANGER system handle. In particular, the QryInfo log entry type will give you the information you're looking for.

Brief examples:
_progres -db mydb -p myproc.p -clientlog client.log -logentrytypes qryinfo:2

assign log-manager:log-entry-types = "qryinfo:3".

For bracketing help, you can also look up the undocumented -zqil and -zqilv client startup parameters in the KB.

How to Diagnose Problems with 4GL Queries: Use Parameters -zqil and -zqilv
http://knowledgebase.progress.com/articles/Article/21216/p

 

[TheMadDBA]

In addition to what Rob said... you can also use ProTop to view session level table and index reads. Or you can use this utility http://www.oehive.org/project/DBActMon

Both of those require the -tablerangesize and -indexrangesize parameters to be set properly on DB startup.. but extremely useful to debug query/program performance.

 

[Cringer]

Come along to my session at the EMEA PUG Challenge (if it gets approved) and you'll learn everything you need to know about query tuning