Re: My View performance is very slow

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 Received on Mon Sep 05 2005 - 05:55:12 CDT