>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.