Union all very slow.

From: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 25 Oct 2006 14:31:16 -0400

All,

 

I am having some problems with a union all view.

 

During my debugging, I commented out either the top or bottom part of
the union all

, and my queries run in a second or two.

 

When I keep both parts of the union all, the query takes 10 minutes.

 

Any thoughts on a hint?

 

Thanks

Randy

Follow-Ups:

Re: Union all very slow.
From: Dennis Williams

Other related posts:

Browse oracle-l