>Why remove it. It's not really an index. The optimizer has decided that the absence of an index has required it to maintain some statistics on a column.
>
>Refer to the CREATE STATISTICS command in the BOL. BTW, you can remove it with the DROP STATISTICS command.
>
>-Mike
Thanks - good to know - 2 questions though:
1 - if they are not indexes, why are they in the sysindexes table and why does SQL tell you it is rebuilding indexes based on their existence as other real indexes are dropped/added?
2 - whatever they are - do they help in query performance at all?
TIA,
Ken B. Matson
GCom2 Solutions