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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2006