_WA_Sys_ ...

[Vijay]

Hello Listers !

I ran the sp_helpindex for a particular table on a CRM db and it returned with a list of 63 indexes, most of which had an index name beginning with _WA_Sys .. followed by what looked like a system generated name.

But when I open the design table in the EM and bring up a list of indexes, I don't find any of the indexes which begin with _WA_Sys .. listed.

I am running SQL 7, sp 2 on NT4, sp 6.

Any light on the anamoly ? Are they some temp indexes created by SQL 7 ?

TIA for any help

Vijay

[Todd]

These are system generated statistics. All is well.


------------
Vijay at 8/22/01 8:46:09 AM

Hello Listers !

I ran the sp_helpindex for a particular table on a CRM db and it returned with a list of 63 indexes, most of which had an index name beginning with _WA_Sys .. followed by what looked like a system generated name.

But when I open the design table in the EM and bring up a list of indexes, I don't find any of the indexes which begin with _WA_Sys .. listed.

I am running SQL 7, sp 2 on NT4, sp 6.

Any light on the anamoly ? Are they some temp indexes created by SQL 7 ?

TIA for any help

Vijay