Re: Sysindexes - column defs (bounce)

> > I am wondering what is the meaning of the last columns in the > sysindexes table: levels, leaves, clust and nunique. > > I am having possible speed problems between 2 databases (one has 160K > records, the other 560K records). Same search using the same indexes > has considerably different speeds. I have RTFM but can't find anything > on these columns. > SQL Ref Manual Chap #2. I don't have one handy - so this is from memory. Clustered is either 'C' or '-'. If 'C' then it is a clustered index. Levels and leaves refer to the index b-tree (how many leaves/levels). nunique is the number of unique values for an index. all are updated by 'UPDATE STATISTICS' cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@boi.hp.com Currently on loan to PLD/PE _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________