Alter column failed due hind_% statistics

  • My fellow co worker and DBA was about to alter a column on a table and received a message like this:

    ALTER TABLE ALTER COLUMN Col1 failed because STATISTICS hind_64

    accesses this column

    The puzzle is, I have not manually created those statistics or run Index Tuning Wizard, none of us.

    What else can create this at database level? I have never seen this before. I know that Index Tuning Wizard can create that but again, we have not run that on any of the databases.

    By the way, I have hundred of databases that share the same schema and only two of them are showing this.

  • Old post, but I will answer myself.

    It was Index Tuning Wizard , indeed! But so many years ago that people did not remember or did not ring a bell when I asked.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply