Re: Sysindexes - column defs

goldberg@sccsi.com (Steve Goldberg) wrote: :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. :Solaris OS, Online 5. :Any thoughts would be appreciated. When you ask like this there are too many variabls left for anyone to guess. I wouldn't be too much conserned about the meaning of the sysindexes columns. They sound like they have something to do with the size of the B-tree and whether the index is clustered and/or unique. As to your speed problem. Same search using the same index i take as meaning you have checked your sqlexplain.out file. (If not you can't have any idea at all what index(s), if any, is used.) Do you select one or many rows? What is the timing difference? Have you dropped and recreated the indexes? Have you checked number of extents and fragmentation of them? Have you done anything about it? (Unload/load or alter index to cluster.) What else do you see? Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company