RE: why am I getting an index full scan instead of a fast full scan with an analytic function
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Sat, 16 Jul 2011 17:30:31 -0700 (PDT)
Message-ID: <1310862631.48870.YahooMailNeo_at_web65913.mail.ac4.yahoo.com>
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
Date: Sat, 16 Jul 2011 17:30:31 -0700 (PDT)
Message-ID: <1310862631.48870.YahooMailNeo_at_web65913.mail.ac4.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jul 16 2011 - 19:30:31 CDT