Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Need Sugestion on Which Columns I need To Create A NonClustered Index? RE: Need Sugestion on Which Columns I need To Create A NonClustered Index?

  • June 18, 2013 at 4:05 am

    #1624935

    Ananth@Sql (6/18/2013)

    Thanks Gila Monster for the reply.But There is an exception with out searching which procedures are getting used

    the table and what are the columns getting used is it possible to identify the non clustered index columns?

    No. You can use tools like the SQL Server Profiler and DTA to get some suggestions.

    But these are only suggestions which should never be accepted without proper analysis and testing.

    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/