EM in SS2000

In EM when I right-click on a database and choose "view", "taskpad" I get a
list of tables. Under some of the tables, I see the names of indexes that I
recognize but then I also see something like hind_909246294_10A_1A or
_WA_Sys_dtCCreationDate_3631FF56. What are these?
Thanks,
--
Dan D.Those are not indexes. They are auto-creates statistics. See the auto create
statistics database
option. You can drop these using DROP STATISTICS, but they were created for
a reason in the first
place, so best is most often to leave them.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
> In EM when I right-click on a database and choose "view", "taskpad" I get
a
> list of tables. Under some of the tables, I see the names of indexes that
I
> recognize but then I also see something like hind_909246294_10A_1A or
> _WA_Sys_dtCCreationDate_3631FF56. What are these?
> Thanks,
> --
> Dan D.|||Thanks.
--
Dan D.
"Tibor Karaszi" wrote:

> Those are not indexes. They are auto-creates statistics. See the auto crea
te statistics database
> option. You can drop these using DROP STATISTICS, but they were created fo
r a reason in the first
> place, so best is most often to leave them.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:A2619689-507C-4EC2-96BF-78A1461F542E@.microsoft.com...
>
>