Re: Union all very slow.

From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
To: Randy.Steiner@xxxxxxxx
Date: Wed, 25 Oct 2006 13:40:10 -0500

Randy,

I'd start by doing an EXPLAIN PLAN on each part and the whole thing. You
didn't mention your Oracle version, but maybe the CBO is getting smart
enough to optimize the entire query, so is making a bad decision.

Dennis Williams

References:

Union all very slow.
From: Steiner, Randy

Other related posts:

Browse oracle-l