Listing used and unused keys
If you want a list of which keys were used and unused, use fetchx instead of fetch. fetchx has the same syntax as fetch except that it has an extra parameter at the end which tells Quantum which additional information is required. Possible values for this parameter are:
0 | No extra information (same as fetch) |
1 | List unused keys |
2 | List used keys |
3 | List unused and used keys |
So, to load data from a fetch file called costs and to see a list of used and unused keys, type:
call fetchx($costs$,c150,c151,3)
Keys are listed one per line, as follows:
Records Used Unused Calls Hits Misses File
7 5 2 893 869 24 cost1
"1" - key unused
"5" - key unused
"2" - key used
"3" - key used
"4" - key used
"6" - key used
"7" - key used
If you use fetchx more than once, the key listings are printed after the summary line to which they refer. If the listing goes over onto a new page the column headings are repeated at the top of the page.
See also