Re: [PHP-DB] Re: [PHP] 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ő