Re: Index statistics

Hi, thanks for your help BUT that's not what I am allowed to do, because this is a change in the customers software. Therefor I need to now if I can extract something from sysmaster or so. Ciao Monika Rabold On Tue, 6 Apr 1999, Obnoxio The Clown wrote: > 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 >