Are these indexes?

SQL 2000
In EM, when I click the Database, the right pane shows 3
tabs and under the Tab "Table Info" it shows info on the
table and shows the names of the indexes, but it also
shows names like this with an index grapic next to it:
_WA_sys_Attr_300424B4
What is this? It's not an index that I've created.
Thx,
Don
Hi Don
No, it's not an index and doesn't take storage space like an index. Is is
just statistics on an unindexed column which can be useful for the optimizer
when coming up with a good plan.
You can read about statistics in the Books Online.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:03d501c4a02b$049889c0$a401280a@.phx.gbl...
> SQL 2000
> In EM, when I click the Database, the right pane shows 3
> tabs and under the Tab "Table Info" it shows info on the
> table and shows the names of the indexes, but it also
> shows names like this with an index grapic next to it:
> _WA_sys_Attr_300424B4
> What is this? It's not an index that I've created.
> Thx,
> Don
>
|||Hi,
These are statistics (name start with _WA) and are not indexes. If
you have auto create statistics on option set for the database and query on
a column that column has no index then sql server will create the statistic
for that column start with the name _WA_SYS_.
Thanks
Hari
MCDBA
"Don" wrote:

> SQL 2000
> In EM, when I click the Database, the right pane shows 3
> tabs and under the Tab "Table Info" it shows info on the
> table and shows the names of the indexes, but it also
> shows names like this with an index grapic next to it:
> _WA_sys_Attr_300424B4
> What is this? It's not an index that I've created.
> Thx,
> Don
>