1. Does creating more indexes in a cdx give a higher probability of corrupting an index?

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?

Thanks for sharing your expertise in this area. It is greatly appreciated.

Marcus.