auto create index

Author

auto create index

Cordelia
Guest

Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:

Total Posts: N/A

auto create index

There are these indexes that gets created automatically by
SQL. They all look like '_WA_Sys_*'. I wasn't able to
find any information on it. Information like why are they
necessary, how are they used, etc.

Report this post to a moderator

11-25-02 06:23 PM

IP: Logged

James Hunter Ross
Guest

Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:

Total Posts: N/A

Re: auto create index

I believe those are actually statistics pages; I know for sure that it is
safe to ignore them. They are for SQL Server internal use. I did find
something about them once, I think here in this newsgroup, but it was a
while ago.

James

Report this post to a moderator

11-25-02 10:23 PM

IP: Logged

Tibor Karaszi
Guest

Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:

Total Posts: N/A

Re: auto create index

Yep. Check out the CREATE STATISTICS command in BOL. And I think that Kalen has info on this in
the "Inside SQL Server" book.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver

"James Hunter Ross" <jhr@delta.net> wrote in message news:eMMKp#MlCHA.3752@tkmsftngp08...
> I believe those are actually statistics pages; I know for sure that it is
> safe to ignore them. They are for SQL Server internal use. I did find
> something about them once, I think here in this newsgroup, but it was a
> while ago.
>
> James
>
>

Report this post to a moderator

11-26-02 12:23 PM

IP: Logged