Invalid indexes in sysindexes
-
I've taken over responsibility for maintaining the health of a production database. I've been trying to resolve fragmentation issues. (See my related question concerning varying results from dbcc showcontig). DBCC showcontig is displaying results for two indexes on a table, a primary key index and another index. Running dbcc indexdefrag for the second index results in an error on parameter 3, the index name. The index does appear on sysindexes. However, if I try to view the indexes for the table in Query Analyzer object browser or through Enterprise Manager, this index does not appear. Its as if it was created, deleted but still remaining in sysindexes. Does anyone have any idea what might be going on here?
Gordon Pollokoff
"Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones
-
Sysindexes holds more than just indexes. If you see entries such as _wa_sys_etc then these are system generated statistics.
Similarly, if you have generated manual statistics then these will also show up in there.
-
Thanks David. Actually, a little more research turned up the answer. The missing index was for text data (indexid=255)
Gordon Pollokoff
"Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply