Post reply

relationship between statistics and indexes

  • June 30, 2011 at 11:25 am

    #252933

    Hello all.

    I have a table called 'Prt_cash_table'. In this table i have a column called as 'portfolio' which in int Datatype.

    I am changing this Datatype from int to varbinary(max) for some business requirements.

    So to serve the needs, i am dropping all the indexes and constraints on the column and then i am altering the table for the new Datatype i.e. varbinary(max)

    So my question is: What if i have statistics defined on this column at the first place? Would it let drop the index?

    What happens if i drop the index without dropping statistics defined on to it. Please let me know.

    thanks

  • June 30, 2011 at 12:05 pm

    #1346680

    Dropping the index will drop the stats associated with that index.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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