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

Home -> Community -> Usenet -> c.d.o.server -> Influence of index structure to insert performance

Influence of index structure to insert performance

From: <suriawan_at_gmx.de>
Date: 15 Feb 2006 14:21:30 -0800
Message-ID: <1140042090.363702.213310@g14g2000cwa.googlegroups.com>


Hello,

I have table A and it has columns: col_1, col_2, col_3, .., col_n. Is there any performance different for insert operation if I create an unique index on (col_1, col_2, col_3) or a unique index on (col_3, col_2, col_1)? Is clustering_factor an issue for the insert?

Thank you.

Regards,
Suriawan Received on Wed Feb 15 2006 - 16:21:30 CST

Original text of this message

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