Message-Id: <10598.115407@fatcity.com> From: Siva_Chintalapati Date: Wed, 23 Aug 2000 23:27:41 +0530 Subject: RE: Indexing DATE column This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C00D2B.ADC8BCF0 Content-Type: text/plain What is B-Tree Index and function based index. Siva > ---------- > From: Helmut Daiminger[SMTP:hdaiminger@vivonet.com] > Reply To: ORACLE-L@fatcity.com > Sent: Thursday, August 24, 2000 12:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Indexing DATE column > > 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 > > -- > Author: Helmut Daiminger > INET: hdaiminger@vivonet.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@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). > ------_=_NextPart_001_01C00D2B.ADC8BCF0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Indexing DATE column

What is B-Tree Index = and function based index.

Siva