Index fields order
Hi,
I have several tables that can grow to be very large with the time.
In each table 3 first fields that my primary key consists of are located in the following order:
field1 binary(16),
field2 smallint,
field3 datetime
while primary key is composed like this:
primary key(field3, field1, field2).
Is it possible that such order mismatch impacts on insert performance?
Thank you,
Andrey
Subject
Views
Written By
Posted
Index fields order
3407
May 14, 2007 08:35AM
2168
May 14, 2007 09:14AM
2093
May 22, 2007 03:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.