My understanding from the mysql docs is that indexing is to be used primarily for speeding queries on often used tables. This particular table is to be queried quite a bit , but almost entirely using the priamry key. So, I assumed that making the primary key an index would speed table searches. However, it prompted me to ask the question, are primary keys already optimized for some sort of indexing and searching? So then I emailed the list.
Carl On Sat, 6 Apr 2002, Paul DuBois wrote: > At 18:28 -0500 4/6/02, Carl Schmidt wrote: > >On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote: > > > >> Your message cannot be posted because it appears to be either spam or > >> simply off topic to our filter. To bypass the filter you must include > >> one of the following words in your message: > >> > >> sql,query > >> > >> If you just reply to this message, and include the entire text of it in the > >> reply, your reply will go through. However, you should > >> first review the text of the message to make sure it has something to do > >> with MySQL. Just typing the word MySQL once will be sufficient, for example. > >> > >> You have written the following: > >> > >> If I index a primary key, is that considered overkill? In other words, I > >> know that a primary key is _the_ unique identifier into the table already. > >> > > > Carl > > It's overkill. Out of curiousity, why are you considering doing such a > thing? > --------------------------------------------------------------------- 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