SQL2K EntMgr DB Taskpad View - Where do all the indexes come from?

microsoft.public.sqlserver.tools

6 Feb 2006 12:15 PM

Paul

Hi,

When I use taskpad view in Enterprise Mgr on a DB I can see a lot of indexes
that don't appear under the index view in Q.A. or in Manage Indexes in E.M.
Where do these come from?

They have what appears to be system generated names like
_WA_Sys_ColumnName_07020F21.

Just curious!

Paul

6 Feb 2006 1:58 PM

Andrew J. Kelly

The are not indexes, they are statistics. Some of the tools incorrectly
report them as indexes. To find out more info on them take a look in
BooksOnLine under CREATE STATISTICS and the associated entries.

--
Andrew J. Kelly SQL MVP

Show quote

"Paul" <paulatuceless.aten.ie> wrote in message
news:eqsD2bxKGHA.2392@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> When I use taskpad view in Enterprise Mgr on a DB I can see a lot of
> indexes that don't appear under the index view in Q.A. or in Manage
> Indexes in E.M. Where do these come from?
>
> They have what appears to be system generated names like
> _WA_Sys_ColumnName_07020F21.
>
> Just curious!
>
> Paul
>