Re: Index statistics

Monika, Use the command SET EXPLAIN ON; before your SQL statement. I.e. in your SQL script, you say: SET EXPLAIN ON; SELECT * FROM table blah, blah, blah; This will create a file called sqexplain.out in your current directory which will give you the query path. >how can I find out if an index is used? Is there a count in sysindexes or >some where else that is incremented when a certain index of a table is >used in a query plan? HTH. -- "I'll Be Back" Obnoxio ************************************************ Sane? Hell, if I was sane, why would I be here? Get Your Private, Free Email at http://www.hotmail.com