Re: Creating extended stats on a ASCENDING/DESCENDING index
Date: Wed, 6 Jun 2012 19:21:19 +0000 (UTC)
On Tue, 05 Jun 2012 22:39:55 +0100, Jonathan Lewis wrote:
> Is the index really a single column index, or is this just an indication
> of the type of thing you're trying to do ?
I am just trying to answer the question asked by developers.
> If it's a single column index with the column declared as descending
> then it's a mistake. Any time you defined EVERY column in an index to be
> descending it's a mistake, the single column is just a special case -
> Oracle can use a (non-descending) B-tree index equally well in ascending
> or descending order.
As usual, you're spot on.Received on Wed Jun 06 2012 - 14:21:19 CDT