Best practices for using MySQL index

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ő