It may or may not help you. It totally depends on your query.
Sandeep.
-----Original Message-----
From: Rocky Welch [SMTP:rockyw_99_at_yahoo.com]
Sent: Sunday, August 06, 2000 11:38 PM
To: Multiple recipients of list ORACLE-L
Subject: Compound Indexes...
Hi All!
Hope your weekend is good. I have a large table (over a million
rows) that
has multiple compound indexes. These indexes contain 2 common
columns.
Should i put those 2 cloumns in their own index? I think this would
increase performance on inserts without hurting reads. Any thoughts?
TIA,
=====
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Author: Rocky Welch
INET: rockyw_99_at_yahoo.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 Sun Aug 06 2000 - 12:57:27 CDT
