Re: Re: [PHP] Best practices for using MySQL index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread 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ő

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux