Re: why am I getting an index full scan instead of a fast full scan with an analytic function

From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 15 Jul 2011 12:40:22 -0700
Message-ID: <CAGXkmivCVd64gJ+LWSQB7g=LyrXT=GfCbU7+UJ5xrLHB0C1_ZA_at_mail.gmail.com>

What is the DDL for the table & index?

On Fri, Jul 15, 2011 at 12:13 PM, Dba DBA <oracledbaquestions_at_gmail.com> wrote:
> 2 queries. On analytic and one group by. They produce the same output.
> Analytic Query: Oracle chooses an index full scan
> Group By: Oracle chooses a fast full scan.
> I can't figure out why Oracle would ever want to do a regular 1 block at a
> time full scan on a 21 gb index.

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 15 2011 - 14:40:22 CDT

This message: [ Message body ]
Next message: Gus Spier: "Re: errors while RECOVERING DATABASE, log included, please help"
Previous message: Dba DBA: "why am I getting an index full scan instead of a fast full scan with an analytic function"
In reply to: Dba DBA: "why am I getting an index full scan instead of a fast full scan with an analytic function"
Next in thread: Jorgensen, Finn: "RE: why am I getting an index full scan instead of a fast full scan with an analytic function"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message