Can anyone explain me why there are (_wa) indexes in my
databases when "real" indexes exists. Meaning: I have an
automatic index "showing" an index that has already been
created... any explanation?
The '_wa' indexes are statistics. They are essential for the SQL optimizer
to decide on a good, efficient query plan.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"" <anonymous@.discussions.microsoft.com> wrote in message
news:82ae01c431e6$21bd4df0$a301280a@.phx.gbl...
> Can anyone explain me why there are (_wa) indexes in my
> databases when "real" indexes exists. Meaning: I have an
> automatic index "showing" an index that has already been
> created... any explanation?
sql
No comments:
Post a Comment