Post reply

Is good that create create index after data update

  • July 27, 2010 at 11:29 pm

    #387444

    Hi All,

    I am having a table with 10 columns and more than ten million records.

    Now i have to add one column, update some rank value with that column and finally i have

    to create the non-clustered index for the same.

    My question here is, which is best (Performance wise).

    First fill the column with Rank function and create the index.

    or

    Create the index and fill the column with Rank function

    Thanks in advance.

    Regards,

    Ramesh.P

  • July 28, 2010 at 2:23 am

    #1199112

    The performance of the first one is better than the second.

    The query efficiency will be improved largely by adding the appropriate index, but will slower data modification operation, because the index statistics must be maintained also.:-P

  • July 28, 2010 at 2:52 am

    #1199119

    Thank you very much.

    I going to apply.

    Regards

    Ramesh.P

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

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