Lisa R. Clary wrote:
I have 3 individual views (average #records=76,000) with the exact
same variable names and datatypes. There is another view that is the
union of the 3 individual views. If I use a count(*) operation (in
sqlplus) on the view that is the union (or the individual view), I
Thanks for the input. The individual views are pretty complex , so I will
try to reorganize starting from a combined view. I do want try the union
all with an outer select distinct to remove duplicates to see if that will
help.
thanks again,
lc
- Original Message -
To: Multiple
I have3 individual views (average
#records=76,000) with the exact same variable names and datatypes. There
is another view that is the union of the 3 individual views. If I use a count(*)
operation (in sqlplus) on the view that is the union (or the individual view), I
run out of temp space
Maybe the UNION is trying to resolve duplicates that it doesn't
have to??? i.e. requiring a sort
Have you tried UNION ALL
Cheers
Jeff Herrick
On Sat, 30 Nov 2002, Lisa R. Clary wrote:
I have 3 individual views (average #records=76,000) with the exact same variable
names and datatypes.