• @tom:

    My answer (Yes) is based on the "question":

    ...my indexing will help on this table or should I create index in some other way to optimise performance...

    which is close to "it depends" from my point of view.

    But at a second glance I realize that the option "no indexes at all" would have been ruled out.

    Therefore, I accept your answer as being more appropriate.



    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]