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.
> 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
>> >> 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
>> > > Carl
>> It's overkill. Out of curiousity, why are you considering doing such a
> > thing?