Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ordered_hint

Re: ordered_hint

From: <cybotto_at_yahoo.com>
Date: 22 Sep 2005 14:54:14 -0700
Message-ID: <1127426054.366280.250820@g47g2000cwa.googlegroups.com>


You will need to spike the view with hints so it's not behaving unpretictable. tom will tell not to use hints and let Orcales CBO sort it out. You are looking for a hash join but then with ORDERED is exaclty what to do when not to use them.

You can try to put the view as full sql statement as inline view and spike it with hints or not and see what is comming out.

The query is begging for a full table scan on t1 and maybe on some others in the view as result. Once CBO ist starting with it will do all sorts of stuff and forget about it straight away.

For what this excersise is about by the way? Received on Thu Sep 22 2005 - 16:54:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US