Long query execution times for union
Date: 1996/08/13
Message-ID: <3210E749.41C6_at_chevron.com>#1/1
I've got two selects that are unioned together. If I execute the two
selects seperatly, they each execute in about 5 seconds. Together (in a
view with a union) they take for ever (10+ minutes). What's the deal
with that?
I am adding an extra condition to the selects which I'm also adding to
the view. But, the name of the column that I'm restricting is different
in each view. How does that work anyway?
Basically I've got this:
create view foo as
The reading/calendar date is the field I'm searching on. In the
description of the view, it shows up as calendar_date.
Any hints, clues, suggestions?
select calendar_date, pasbal_code, value (etc, etc..)
union
select reading_date, pasbal_code, value (etc, etc..)
;
Eric Ladner | UNIX/Oracle/Passport Sys-Administration, General
clad_at_chevron.com | Applications Development, etc., etc.
========================================================================
Received on Tue Aug 13 1996 - 00:00:00 CEST