Index creation RRS feed

  • Question

  • Hi,

    I have a table with around 4 lakh to 5 lakh records.This table has a status files and it holds 3 values 'E', 'D' and 'S'

    Is it worth to create index on status field?

    Already there are 5 index on this table.

    Please let me know your thoughts.



    Best Regards, Venkat

    Friday, June 15, 2012 6:15 AM


  • It depends on the queries you run for your table. If you are in doubt use SQL Server Profiler and Database Engine Tuning Advisor.

    In this case Column Store Index (available in SQL Server 2012) would perform well.

    • Marked as answer by Iric Wen Tuesday, June 26, 2012 1:40 AM
    Friday, June 15, 2012 6:34 AM

All replies