Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Function-based Index

Re: Function-based Index

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 12 Dec 2002 00:28:42 -0800
Message-ID: <F001.0051842C.20021212002842@fatcity.com>


I created a test table and build an index on columns t1 and t2.

Explain plan for: select min(t1) from test where t2=4;

was resolved using the index only so I think that will be very efficient.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, December 12, 2002 12:34 AM

> why would you want to create function based index on a column that you are
> not using in the where clause.
>
> for your sql statement a index on cnfr_no would work great...
>
> babu
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, December 11, 2002 4:09 PM
>
>
> >
> > I have the following statement that I would like to create a
> function-based
> > index for:
> >
> > SELECT MIN(tran_dt)
> > FROM ach_tran
> > WHERE cnfr_no = :b1
> >
> >
> > I'd like the index to include columns cnfr_no and tran_dt (in that
order).
> > The examples I've seen are
> > just single-column indexes. Is it possible to have this additional
> > column in a function-based index that
> > is not involved in the actual function? If yes, what would the index
> > creation statement look like?
> >
> > This is version 9.2.0.1 on Sun Solaris 2.6.
> >
> >
> > Thanks in advance for any assistance.
> >
> > Cherie Machler
> > Gelco DBA
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Cherie_Machler_at_gelco.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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: Babu Nagarajan
> INET: orclbabu_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Thu Dec 12 2002 - 02:28:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US