Re: performance question
From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1996/05/10
Message-ID: <4mui7r$geh_at_homer.alpha.net>#1/1
Date: 1996/05/10
Message-ID: <4mui7r$geh_at_homer.alpha.net>#1/1
group by works on the return-set of the query.
Harveypbgh (harveypbgh_at_aol.com) wrote:
> Scenario: I have a complex join with a "group by", which also includes
> several long decodes (each of which references several columns -- the
> decode picks one).
> My question is this: Is the decode resolved BEFORE the joins and the sort
> implied by the group by, or AFTER the joins and the sort. If all of that
> data is being carried along, I'm going to take steps to eliminate the
> decodes!!
> harveypbgh_at_aol.com
-- ************************************************************** * Saad Ahmad * * Senior Software Engineer * * McHugh Freeman & Associates, Inc. * * Ph: (414) 798-7457 * * Fax: (414) 798-8619 * * E-Mail: sahmad_at_mfa.com * **************************************************************Received on Fri May 10 1996 - 00:00:00 CEST