List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 7 2002 12:22am
Subject:Re: Index a primary key
View as plain text  
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 mysql@stripped 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?
Thread
Re: Index a primary keyCarl Schmidt7 Apr
Re: Index a primary keyPaul DuBois7 Apr
  • Re: Index a primary keyCarl Schmidt7 Apr
Re: Index a primary keyPaul DuBois7 Apr