>1. Does creating more indexes in a cdx give a higher probability of corrupting an index?
Just the fact there is more to update and it could take longer, but I don't think it really give it a higher probability.
>
>2. If I would like to use a SELECT statement with ORDER BY lname,fname -- should I have two separate indexes for lname and fname?
ORDER BY works on the result set, so the indexes would have no effect on this.
>
>Thanks for sharing your expertise in this area. It is greatly appreciated.
>
>Marcus.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer