Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Influence of index structure to insert performance
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