Re: My View performance is very slow

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Sep 2005 09:40:13 -0700
Message-ID: <1125679164.537215@yasure>

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

Indexes, of any kind, have nothing to do with ordering.

In 10g one might consider a sorted hash cluster as a solution.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Sep 02 2005 - 11:40:13 CDT