Re: ordered_hint

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