Re: Group by Optimization
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"
Subject
Views
Written By
Posted
7358
December 01, 2005 08:27AM
3972
December 03, 2005 06:07AM
3621
December 05, 2005 11:32AM
Re: Group by Optimization
3475
December 09, 2005 04:53PM
3400
December 05, 2005 11:29AM
7818
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.