Jeremy Zawodny wrote:
> On Sat, Jul 07, 2001 at 07:22:19AM -0700, Ken Sommers wrote:
>
>> Does it make any sense to create an index on the primary key?
>
> Primary Keys are automatically indexed. In fact, you might say that a
> primary key is just a special type of index (it is).
There are some things in SQL standards which are helpful for documentation or better
understanding reasons.
It is nice to have some small kind of self-explaining table structure like this.
Byt Paul and Jeremy are also right (actually they both are always right ;)).
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
/_/ /_/\_, /___/\___\_\___/ Hong Kong, China
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
