Index Questions

[j4n]

Hi folks.
Is there any sort of index statistics in a Progress database? Somthing like: table customer has 4 indexes. 70% of all searches are done by using index 1. the other 3 were each used in 10% of the queries.
I know that the compiler determines which index is used and that I can look it up using the xref-option at compile time. But this only documents the static queries which are getting less and less...
Another thing is the "USE-INDEX" option. I know it's bad with a Progress database in the background - but what about Oracle or MS-Sql dataserver. It seems that the compiler doesn't save/generate which index needs to be used for a query. Any thoughts on this?

 

[Cringer]

Try having a look at

proutil icmasliv -C ixanalys > c:\temp\ixanalys.txt

you have to run it from proenv and be in the directory where the db is located.

 

[TomBascom]

Runtime index utilization data is available from _indexStat.

It is very interesting data.

ProTop has a pre-built screen that will show it to you.

You need to start the db with -indexrangesize X or you will only get the first 50 indexes.