Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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,
rockyw_99_at_yahoo.com