> ... why would anybody want a descending index in the first > place? What doe a descending index give you that you > don't have with an ascending index?
I believe it's an optimization in some DBMSs for multi-column sorting: create index i on t (c1 asc, c2 desc); otherwise, I agree with you. Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]