MySQL Forums
Forum List  »  Optimizer & Parser

Re: Group by Optimization
Posted by: Björn Steinbrink
Date: December 09, 2005 04:53PM

Jay Pipes wrote:
> Bj�rn Steinbrink wrote:
> > I assume that DB2 does use more than one key
> at a
> > time and thus is faster.
>
> This is not necessarily true. Most likely, the
> issue is that the OP has put an index on only
> state, and not state and city, but in DB2 the
> index may include both fields... ?
>

Yeah, might be right, of course. I just assumed that the tables are identical on both boxes, as the OP said "We also have this table on a DB2 box"

Options: ReplyQuote


Subject
Views
Written By
Posted
6736
December 01, 2005 08:27AM
3679
December 03, 2005 06:07AM
3298
December 05, 2005 11:32AM
Re: Group by Optimization
3168
December 09, 2005 04:53PM
3135
December 05, 2005 11:29AM
7328
December 14, 2005 02:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.