Chris L. wrote:
>>> On Jul 5, 5:50 pm, valigula <valig..._at_gmail.com> wrote:
>>>> Hi All
>>>> Need top repeat a select 3 times but with differents where condition.
>>>> I tried to repeat the selects and after use a couple of union to join
>>>> then, but it takes toooo long.
>
> Instead of UNION you could use OR in your WHERE clause.
>
> Select * from sometable where name = 'JOHN'
> union
> Select * from sometable where salary > 500
> union
> Select * from sometable where state <> 'NY';
>
> Select * from sometable where name = 'JOHN' OR salary > 500 OR state
> <> 'NY';
>
> If your queries take too long, try and index the tables. The index
> fields must match your WHERE fields.
Very inefficient compared with WITH.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 05 2007 - 12:50:29 CDT
