Execution plan for queries using minus/union/intersect

From: GBA-DBA <gba.oraclel_at_gmail.com>
Date: Thu, 22 Oct 2009 15:49:14 -0500
Message-ID: <d7e2170910221349w25aff09esaab3131276263810_at_mail.gmail.com>



Hello list,

Let's say I have select a, b, c from t1 (union/minus/intersect) select a, b , c from t2

Is there any way to avoid the sort unique step (for each table) that takes place before the execution of the set operation?

A unique index maybe or by having the tables sorted by the columns used in the select statement?

I don't have a database around to test it, that's why I'm asking.

Thanks for your help.

-- 
Regards
GBA

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 22 2009 - 15:49:14 CDT

Original text of this message