Re: SQL*PLUS and INDEX

From: Sigmar Wiesmayr <wis_at_ecolog.at>
Date: Mon, 27 Nov 2000 23:47:46 GMT
Message-ID: <8FFAD058wisecologat_at_192.168.253.100>


mcb_at_fightspam.sd.znet.com (Matt B.) wrote in <t1t653ho49t164_at_corp.supernews.com>:

>Most likely no. [..]
>Subqueries are killers and should be avoided wherever possible.

I agree. But perhaps you get a change when using the hint PUSH_SUBQ, which tells the optimizer to execute the subquery first. Is a good idea, when you expect small resultset from the subquery.

-- 
Sigmar
Received on Tue Nov 28 2000 - 00:47:46 CET

Original text of this message