Re: Index a primary key

2002-04-06 Thread Paul DuBois
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 pr

Re: Index a primary key

2002-04-06 Thread Carl Schmidt
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.

Re: Index a primary key

2002-04-06 Thread Paul DuBois
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,q

Re: Index a primary key

2002-04-06 Thread Carl Schmidt
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 includ