Re: Index query.

Hi Senthilkumar,

  Those rows that have null values will not find a place in the Index.

  The recommended practice would be to store default values in those   column instead of null value. This would be helpful if you want to   access the table to select rows with that column having null value.   This would avoid a FULL TABLE scan assuming that the cardinality is   low for this field.

Regards
Rajagopal Venkataramany

----Original Message Follows----
From: SENTHILKUMAR NALLATHAMBI <senthilkumar.nallathambi_at_tatainfotech.com> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Index query.
Date: Wed, 10 May 2000 22:26:23 -0800

Hi gurus,

        I want to know the effect of nulls on an indexed field and the usage of the Index.

        Any ideas will be of great help.

NS.

--
Author: SENTHILKUMAR NALLATHAMBI
   INET: senthilkumar.nallathambi_at_tatainfotech.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).

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com