Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Compound Indexes...

Compound Indexes...

From: Rocky Welch <rockyw_99_at_yahoo.com>
Date: Sun, 6 Aug 2000 10:02:00 -0700 (PDT)
Message-Id: <10581.113925@fatcity.com>


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/ Received on Sun Aug 06 2000 - 12:02:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US