Hi,

I would like to know which index has been usage and which one never been used.

Is anybody know how to do this??

Thanks!!

take a look at

set explain on

the command will generate a file witch will tell you everything
about your query

Cheers

Artem

Thanks Artem,
But, is there any quickly manner more than "set explain on" to verify index?
And the unused index would be impact the performance ???

Thanks!!

Hi,

If the index is detached from the table you can check the output from onstat -g ppf. Then you'll match the 'partnum' field with the contents from sysfragments for each database.

I also think that the output from sysptnhdr/sysptprof in sysmaster will help. Take a try...

And the answer to your second question is yes: an index is a performance problem for inserts/deletes/updates...

Hope it helps.

I'll try it,
Thanks a lot !!