>Craig,
>
>Thanks for your help!
>
>Care to elaborate on your findings.
>
>David
>
>>Glad to hear that you sped things up. However, you should be aware that INDEX ON is not always faster then ORDER BY. The results will be different depending on the size of the result set.
If the result set is small, it may take longer to build an index than to order it in the SQL SELECT.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer