Query Info Log (-zqil parameter)

It is useful to check index usage at run-time, while XREF is reporting 
indexes at compile time. It also will give information about query bracketing.

Before V9 parameter works only with local clients.
In Windows it produces General Protection Faults (GPFs) with 
Progress 8.1 and below, though it works in 8.3 and above.
It does not work with find and can-find.
Writes index usage report to a database log file. 
And it does that for every query, so your log file will grow very very fast. 

Examples:

1. For each customer where cust-num > 10
It will write to log file
18:23:08 INDEX 12 1 0 (6157)
Here '12' is _index._idx-num of the "cust-num" index. 1 0 means one range match.

2. For each customer where cust-num < 10
18:23:08 INDEX 12 0 1 (6157)

3. For each customer where cust-num = 10
18:30:18 INDEX 12 1 1 EQUALITY (6154)
That means we have one equality match. EQUALITY word means that all components of 
the index participate in an eqality match. 

4. Let's try another index
For each customer where country = "USA" 
or
For each customer where country begins "U"
or
For each customer where country > "A" and country < "Z"
All the above will produce
18:26:40 INDEX 14 1 1 (6157)
Here '14' is _index._idx-num of the "country-post" index.
We have equality or 2 range matches on the first component of the index. 
BEGINS is the same as 2 range matches.
There is no EQUALITY word here because it is multi-component index and 
bracket on the first component.

In all above examples index had a bracket on the first component only.

5. For each customer where country = "USA" and post > 19115
18:26:40 INDEX 14 2 1 (6157)
We have equality on the first component and a range on the second. 

6. For each customer where country begins "U" and post > 19115
18:26:40 INDEX 14 1 1 (6157)
With "begins" instead of equality on a country field in the same example we have
no bracketing on the second component.

7. Finally, For each customer where country = "USA" and 
post = 19115 will give us
18:30:18 INDEX 14 2 2 EQUALITY (6154)

8. When you have INDEX idx-num 0 0 there are no bracketing, that is the case when 
you will have WHOLE-INDEX in XREF. In short, the maximum of that two numbers 
after _idx-num will give us a number of components that we have bracketing on.

When a query uses a word index the -zqil parameter is the only way to observe 
what index is used at run-time. 

See the Dan Foreman’s PPTG book for more info (Progerss msg 1848).