Board index » delphi » How to delete a entry for a hidden index

How to delete a entry for a hidden index

Hello
I have some entries in the sysindexes table which are generated by MSSQL.
Does anybody know how can entries cand be deleted ?
If i try the command DROP INDEX .... the message is : "The index does not
exists",
but i can see the index with a select  from sysobjects or sp_helpindex.
These indexes have the 5th bit in status field set on 1.

Any suggestion would be apreciate.

Thanx,
Laura

 

Re:How to delete a entry for a hidden index


The problem is solved thanx to "Books Online"

The index was in fact a statistics, and i deleted with DROP STATISTICS ....
Anyway, is strange this SQLDMOIndex_Hypothetical is strange.
It is generated automaticaly, and if  auto update statistics is on, the
update for the table is slow,
because of rebuilding these indexes.

L.

Quote
Laura Dragulin <la...@ats.minisat.ro> wrote in message

news:8qsqab$8d912@bornews.borland.com...
Quote
> Hello
> I have some entries in the sysindexes table which are generated by MSSQL.
> Does anybody know how can entries cand be deleted ?
> If i try the command DROP INDEX .... the message is : "The index does not
> exists",
> but i can see the index with a select  from sysobjects or sp_helpindex.
> These indexes have the 5th bit in status field set on 1.

> Any suggestion would be apreciate.

> Thanx,
> Laura

Other Threads