Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: My View performance is very slow
I found one thing the select is having an order by whcih is the culprit
for the performace.
Ex: select .... from msc_item_attributes_v where ..... order by
item_name ,organization_code
We get the order by columns values based on functions. Can anyone tell me how can i order the results without hanpering the performance. Received on Fri Sep 02 2005 - 05:48:31 CDT