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

Written By
December 01, 2005 08:27AM
December 03, 2005 06:07AM
December 05, 2005 11:32AM
Re: Group by Optimization
December 09, 2005 04:53PM
December 05, 2005 11:29AM
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.