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: Mon, 18 Jul 2011 08:50:49 -0700 (PDT)
Message-ID: <1311004249.6964.YahooMailNeo_at_web65911.mail.ac4.yahoo.com>
I was going by what Oracle things final result set record count is, if you look at the execution plan its 378M for analytical query versus 18M for the other query. In reality it may not return every single record in the table, but the those 2 queries are not the same and they don't produce the same output. Add distinct clause to the outer section of analytical query and check the execution plan. Thanks, Sai http://sai-oracle.blogspot.com
Date: Mon, 18 Jul 2011 08:50:49 -0700 (PDT)
Message-ID: <1311004249.6964.YahooMailNeo_at_web65911.mail.ac4.yahoo.com>
I was going by what Oracle things final result set record count is, if you look at the execution plan its 378M for analytical query versus 18M for the other query. In reality it may not return every single record in the table, but the those 2 queries are not the same and they don't produce the same output. Add distinct clause to the outer section of analytical query and check the execution plan. Thanks, Sai http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 18 2011 - 10:50:49 CDT