Re: My View performance is very slow

On 5 Sep 2005 03:55:12 -0700, siddu_htc_at_yahoo.com wrote:

>Hi,
>
>I mean my order by columns are now changed to joins.
>i.e earlier the values are derived using functions,now i am joining
>tables and getting it.
>Even then, if i use order by clause on top of view it is very slow.
>Please help.
>
>Ex: select .... from msc_item_attributes_v where ......
>order by item_name ,organization_code

And your explain plan is....?

--
Sybrand Bakker, Senior Oracle DBA