• You might want to read this[/url] article to verify your data types are as efficient as possible.

    Aother issue might be the indexing strategy itself. Maybe you can narrow it down by moving some of the columns to the INCLUDE section. It's also possible that some of your indexes are either redundant or not queried often enough.

    What method did you use to define the indexes? (I surely hope the answer is not DTA...).

    Do you regulary run a missing index as well as an unused index check?

    Without table def including definition for all indexes as well as the results of sys.dm_db_index_usage_stats (including the index name based on sys.indexes) for this specific table it'll be hard to tell...

    Edit: Link added.



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]