DBREINDEX problem 1

[Will192]

If I issue the following command:

DBCC DBREINDEX (VPOFFICE)

I get the following error:

Server: Msg 169, Level 15, State 2, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I have not seen this before. I ran a pretty big profile through the index tuner last night and now I have 1 index and 20 statistics created on this table. 20 statistics seems like too many to me. Is this hurting performance or causing this error?

 

[eramgarden]

do u have Possibly "hypothetical indexes" (...hind...)?

1.SP_helpindex <table name>

To list all indexes including the hypothetical indexes (hind)


2.DROP INDEX yourtable.hindxxxx

3. not sure but u might want to run sp_updatestats.

see if this works,

 

[Will192]

There was a lot of statictics for the table, around 20. I have another table that has about double that.

Could delete all the statistics in production and then watch what is created over a day or two of activity? Assuming that I have auto create and update stats enabled.