Re: Re: Best practices for using MySQL index

i agree. But InnoDB not fast like other, but this using for transaction. u should try to examine, if you choose performance.. chose other. If u use transaction, INNODB perhaps u can use? *sry my bad LANG Gergely Hodicska wrote:

Hi!

While this is not a MySQL mailing list, I try to give you some hints and keep it short.

There is maybe one important thing which should considered: clustered index. If use InnoDB you can think about to not using a surrogate key but a natural one which best support the query which you will use in most cases. An InnoDB table's primary key is a clustered index and querying against it is very fast. Best Regards, Felhő