RE: Function-based Index

Cherie,

AFAIK, a plain old index works just fine with Min and Max functions. However, you might need tran_dt first in the index or have its own index.

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Cherie_Machler_at_gelco.com [SMTP:Cherie_Machler_at_gelco.com]
>
> 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: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

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).