At 18:51 -0500 4/6/02, Carl Schmidt wrote: >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.
Primary keys are a type of index, so you do get the benefits of indexing by establishing a primary key. > >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