ED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 7:19 PM
Subject: Re: Lookup tables and indexing
> On Wed, Feb 27, 2002 at 09:14:51PM -0800, Jeff Kilbride wrote:
> >
> > Is there a rule
On Wed, Feb 27, 2002 at 09:14:51PM -0800, Jeff Kilbride wrote:
>
> Is there a rule of thumb for small tables and whether they should be
> indexed? I have several small, two column lookup tables with few
> rows (100-300) and some very small tables (< 10 rows). I don't plan
> on indexing the very sm
Jeff,
Friday, March 01, 2002, 12:05:36 AM, you wrote:
JK> Thanks for the reply. Does it actually hurt to index them on lower volumes
JK> of traffic? Or is it neglible?
Just try and you'll see, it really depends on your context.
JK> --jeff
>> Jeff,
>> Thursday, February 28, 2002, 7:14:51 AM, y
Hi Egor,
Thanks for the reply. Does it actually hurt to index them on lower volumes
of traffic? Or is it neglible?
--jeff
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 28, 2002 8:40 AM
Subject: Look
Jeff,
Thursday, February 28, 2002, 7:14:51 AM, you wrote:
JK> Is there a rule of thumb for small tables and whether they should be
JK> indexed? I have several small, two column lookup tables with few rows
JK> (100-300) and some very small tables (< 10 rows). I don't plan on indexing
JK> the very
Is there a rule of thumb for small tables and whether they should be
indexed? I have several small, two column lookup tables with few rows
(100-300) and some very small tables (< 10 rows). I don't plan on indexing
the very small ones, but what about the others?
Thanks,
--jeff
sql,query
--
