On Thu, Feb 21, 2002 at 11:29:28PM -0800, Jeff Kilbride wrote:
> Hmmm...
>
> Ok, my original assumption was that if I was grouping by those
> fields in my SELECT, then including them in the index would help --
> if the order of my GROUP BY followed the order of the fields in the
> index.
>
> You
r
not?
Thanks,
--jeff
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 11:19 PM
Subject: Re: Wide Indexes
> On Th
On Thu, Feb 21, 2002 at 08:13:51PM -0800, Jeff Kilbride wrote:
>
> For reporting purposes, I usually use a wide index across all the
> fields that are relevant to creating the reports. So, for example,
> my sales table has this type of data:
>
> sale_id
> sale_date
> salesperson_id
> product_id
>
