Re: why am I getting an index full scan instead of a fast full scan with an analytic function
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- Date: Fri, 15 Jul 2011 12:40:22 -0700
What is the DDL for the table & index?
On Fri, Jul 15, 2011 at 12:13 PM, Dba DBA <oracledbaquestions@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
