Oops. Sorry, meant ORDER BY, not GROUP BY in my response

>>1. Does creating more indexes in a cdx give a higher probability of corrupting an index?
>
>Since it takes more time to update multiple indexes on an insert or edit, I would think technically, yes, if something happened during an update. But generally if everything runs properly, I don't think it will be a factor.
>
>>
>>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?
>
>This is an interesting question I haven't really thought about. I imagine one of the SQL experts will give a definitive answer. However, I believe the GROUP BY operates on the result set, not the source ( but I may be wrong ), in which case it may have no effect.
>
>Bill
>
>>
>>Thanks for sharing your expertise in this area. It is greatly appreciated.
>>
>>Marcus.