Re: Pushing predicates - Analytic functions in Views
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 25 Mar 2009 09:59:15 +0100
Message-ID: <49c9f264$0$198$e4fe514c_at_news.xs4all.nl>
Jonathan Lewis schreef:
> "Shakespeare" <whatsin_at_xs4all.nl> wrote in message
> news:49c94f0f$0$194$e4fe514c_at_news.xs4all.nl...
>
>
> 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.
>
Date: Wed, 25 Mar 2009 09:59:15 +0100
Message-ID: <49c9f264$0$198$e4fe514c_at_news.xs4all.nl>
Jonathan Lewis schreef:
> "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.
>
Sorry, it was late at night... ;-) and in the meantime I was stressing to get a production system running again after someone "did not change anything"
Shakespeare
(What's in a change?)
Received on Wed Mar 25 2009 - 03:59:15 CDT