RE: Function In Select Statment

That may indeed help, if you're very lucky. However forcing it to use that index could also result in an inefficient query path.

Another possibility, also with drawbacks, is to have a materialized view which contains the function results as a column of the view.

Ian MacGregor
Stanford Linear Acclerator Center
ian_at_slac.stanford.edu

-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org] Sent: Tuesday, January 29, 2002 8:36 AM
To: Multiple recipients of list ORACLE-L

Hamid,
 Why not create a function based index on the column that is being and the data returned will be faster. I do not know if it will help the sort for the order by but the data returned will be available faster. What does your sort area look like? Is it to small to handle the sort and paging out to disk?
ROR mª¿ªm

>>> hamid.alavi_at_quovadx.com 01/29/02 11:05AM >>>
Hi List,
One of our developer using function in his select statment but the problem
is when he is using order by one of the function results column the query is
very slow, Is there any way to use hint for function or some thing to make
quesry faster.
Thanks in advance

Hamid Alavi
Office 818 737-0526
Cell 818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contReceived: from CONNECT-MTA by galotterain information that is PRIVILEGED, CONFIDENTIAL and exempt
from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the original message from your system.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Hamid Alavi
  INET: hamid.alavi_at_quovadx.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).