Re: Pushing predicates - Analytic functions in Views
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 24 Mar 2009 22:53:45 -0000
Message-ID: <zqKdndoxE8jt-VTUnZ2dnUVZ8hOWnZ2d_at_bt.com>
Date: Tue, 24 Mar 2009 22:53:45 -0000
Message-ID: <zqKdndoxE8jt-VTUnZ2dnUVZ8hOWnZ2d_at_bt.com>
"Shakespeare" <whatsin_at_xs4all.nl> wrote in message
news:49c94f0f$0$194$e4fe514c_at_news.xs4all.nl...
> Gokul schreef:
>> Thanks, Jonathan.
>>
>> Actually, the view I use depends mainly on the result of the row_number
>> () in the view.
>>
>> From your explanation, I beleive there is no way out as I expect the
>> result to change based on the row_number().
>>
>> Rgds,
>> Gokul
>
> Which makes me wonder: what is the extra row you get here? 14 vs. 15 rows
> returned....
>
> Shakespeare
> (What's in a row?)
Shakespeare,
The "14 rows returned"/"15 rows returned" in the OP's firstposting were from the plan table on the select from table(dbms_xplan), nothing to do with the data.
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Tue Mar 24 2009 - 17:53:45 CDT