SQL using the index
If I find one index has high buffer read, How to know which SQL use this index?
↪ replying to CHUAN LU
There are a few ways this can be done. The most straightforward way I know is
to switch on SQLTRACE in low mode. Then look for the part number of the index
in the query plan output from "onstat -g his".
Be aware that "onstat -g his" uses decimal partnums and other views may be
using hexadecimal.
Ben.