Re: Indexing DATE column

From: William Beilstein <BeilstWH_at_obg.com>
Date: Wed, 23 Aug 2000 14:24:48 -0400
Message-Id: <10598.115411@fatcity.com>

The standard index works just fine for dates. You should have no need for = a function.

>>> "Helmut Daiminger" <hdaiminger_at_vivonet.com> 08/23/00 02:45PM >>>
Hi!

This is kind of a basic question, but I just wanted to make sure: if I = want
to index a DATE column, do I use a regular B-tree index or do I use a function based index?

This is 8.1.6 on AIX.

Thanks,
Helmut

--=20
Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.com=20

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). Received on Wed Aug 23 2000 - 13:24:48 CDT