Re: My View performance is very slow

From: Robert Klemme <bob.news_at_gmx.net>
Date: Fri, 2 Sep 2005 17:02:44 +0200
Message-ID: <3nr7spF2v8aiU1@individual.net>

DA Morgan wrote:
> siddu_htc_at_yahoo.com wrote:
>> 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.
>
> You can't. And the function likely adds to the misery. There have been
> a number of articles by Tom Kyte (check http://asktom.oracle.com) on
> this issue.

Sorry for jumping right in the middle of the thread. What about a function based index? Wouldn't that help for ordering also? Or did I miss something?

Kind regards

robert Received on Fri Sep 02 2005 - 10:02:44 CDT