Indexes question

Hi Gurus,
When I query a table using sp_MShelpindex in one of my databases I see
following output:-
Name Status Indid
pk_ACTIONS 18450 1
_WA_COMPLETE_6FB49575 8388704 2
Please tell me what are these %_WA_% objects. Are these statistics or
automatically generated indexes created by index tuning wizard?
Thanks in advance
ManuThe "indexes" with names in that format are not indexes, just
statistics. They are not created by the tuning wizard, but they SQL
Server in normal operation. Simply ignore them and you will be fine.
Roy Harvey
Beacon Falls, CT
On Wed, 19 Sep 2007 13:04:04 -0700, manu
<manu@.discussions.microsoft.com> wrote:
>Hi Gurus,
>When I query a table using sp_MShelpindex in one of my databases I see
>following output:-
>Name Status Indid
>pk_ACTIONS 18450 1
>_WA_COMPLETE_6FB49575 8388704 2
>Please tell me what are these %_WA_% objects. Are these statistics or
>automatically generated indexes created by index tuning wizard?
>Thanks in advance
>Manu