MySQL Forums
Forum List  »  Optimizer & Parser

Index fields order
Posted by: Andrey Kondakov
Date: May 14, 2007 08:35AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Index fields order
3352
May 14, 2007 08:35AM
2122
May 14, 2007 09:14AM
2054
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.