Index Question

From: Dwayne Cox <dwaynec_at_infotechfl.com>
Date: Tue, 04 Dec 2001 12:20:10 -0800
Message-ID: <F001.003D4E59.20011204113018@fatcity.com>

Hi All,

If I have an index on a key field of type VARCHAR and double its size from 15 to 30, how will this impact performance? By performance, I mean data retrieval.

I think that if we are talking about small quantities of data (> 500MB maybe?) things would slow some but not appreciably. Am I correct? Or maybe there are other factors I am not considering?

Thanks for your input.

--

Dwayne Cox                                            dwaynec_at_infotechfl.com
DBA, Development Department,  Info Tech, Inc.
5700 SW 34th Street, Suite 1235                   phone: (352) 381.4521
Gainesville, FL  32608                                     fax: (352) 381.4444

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Dwayne Cox
  INET: dwaynec_at_infotechfl.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). Received on Tue Dec 04 2001 - 14:20:10 CST