Re: force use of an index - how to?
From: Telerate <tlrapro_at_hk.net>
Date: 1995/04/20
Message-ID: <3n4fkr$l6v_at_news.hk.net>#1/1
Date: 1995/04/20
Message-ID: <3n4fkr$l6v_at_news.hk.net>#1/1
If I can't choose my column to be stored via an index in descending order, would i get the same effect if I have the following:
(Assume Table A has a column x that has values generated by a sequence number in descending order. Withouth an index, the rows of column x probably is in descending order. Now add an index to column x for Table A. Since the index are sorted in ascending order only, would it be logical to assume that on a SELECT x from A, it would return the rows in descending order?
Thanks for your help.
Regards,
Bill
n
Received on Thu Apr 20 1995 - 00:00:00 CEST