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:
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.comReceived on Wed Jun 06 2012 - 14:21:19 CDT