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

From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
To: free <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 16 Jul 2011 17:30:31 -0700 (PDT)

First of all those 2 queries are not the same, they produce different result 
sets. For the analytical query, it returns every single record in the table 
versus very few records for the other query.

If you include "distinct" in the outer section of analytical query, then you 
will get the same result set for both the queries.

Thanks,
 Sai
http://sai-oracle.blogspot.com

Other related posts:

» why am I getting an index full scan instead of a fast full scan with an analytic function- Dba DBA
» Re: why am I getting an index full scan instead of a fast full scan with an analytic function- Greg Rahn
» RE: why am I getting an index full scan instead of a fast full scan with an analytic function- Jorgensen, Finn
» RE: why am I getting an index full scan instead of a fast full scan with an analytic function - Saibabu Devabhaktuni
» Re: why am I getting an index full scan instead of a fast full scan with an analytic function- Dba DBA
» Re: why am I getting an index full scan instead of a fast full scan with an analytic function- Igor Neyman
» Re: why am I getting an index full scan instead of a fast full scan with an analytic function- Saibabu Devabhaktuni