Re: Creating extended stats on a ASCENDING/DESCENDING index

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 6 Jun 2012 19:21:19 +0000 (UTC)
Message-ID: <jqoajf$a58$1_at_solani.org>



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.

-- 
http://mgogala.byethost5.com
Received on Wed Jun 06 2012 - 14:21:19 CDT

Original text of this message