Re: Question for a guru -?- regarding outer join+hints...

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: Thu, 15 Jul 1999 11:35:54 GMT
Message-ID: <uIjj3.1258$ts3.36381@nnrp4.clara.net>

monsri_at_my-deja.com wrote in message <7mk7ea$akg$1_at_nnrp1.deja.com>... [snip]
>
>and I found:
>
>> SORT AGGREGATE
>> HASH JOIN
>> TABLE ACCESS FULL VIP_ARCHIVE_CONFIG
>> TABLE ACCESS FULL SIE_RAW_DATA_19990713
>with the first query, and:
>
>> HASH JOIN
>> TABLE ACCESS FULL SIE_RAW_DATA_19990713
>> TABLE ACCESS FULL VIP_ARCHIVE_CONFIG
>> SORT AGGREGATE
>> HASH JOIN
>> TABLE ACCESS FULL SIE_RAW_DATA_19990713
>> TABLE ACCESS FULL VIP_ARCHIVE_CONFIG
>with the 2nd one (the latter is then obviously heavier, although the
>code is lighter).
>
>Could anyone please explain me WHY the first query is the best one ??

That second execution plan looks wrong: it should be identical to the first. Did you remember to delete the rows in your plan table between analysing the two queries?

Dave.
--
Remove "nospam" from my address to reply by email Received on Thu Jul 15 1999 - 06:35:54 CDT