Re: My View performance is very slow

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Fri, 02 Sep 2005 17:45:25 +0200
Message-ID: <43187378$0$24153$9b4e6d93@newsread4.arcor-online.net>

Robert Klemme schrieb:
> 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
>

IMO, Mr. Morgan is correct, function based index would not help avoid sort if you use JOIN ( sorry for that wording, i can't express it clear, but i mean the sort operation of ORDER BY, not the of JOIN ) .

Best regards

Maxim Received on Fri Sep 02 2005 - 10:45:25 CDT