Re: Re: Best practices for using MySQL index

From: Date: Sat, 10 May 2008 06:30:17 +0000
Subject: Re: Re: Best practices for using MySQL index
References: 1 2  Groups: php.db php.general 
Request: Send a blank email to php-db+get-44971@lists.php.net to get a copy of this message
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ő

« previous php.db (#44971) next »