Is union better than or

From: Michaël Fiey <m(dot)fiey(at)futuresoundtech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Is union better than or
Date: 2000-08-03 17:45:24
Message-ID: 000801bffd72$9abc6440$6400a8c0@pc03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I wonder what's the best between these 2 commands :
First command :
SELECT * FROM TABLE1 WHERE COL1 like 'A%' AND COL2 LIKE 'B%' AND (COL3 LIKE 'C%' OR COL4 LIKE 'D%')

Second command :
SELECT * FROM TABLE1 WHERE COL1 like 'A%' AND COL2 LIKE 'B%' AND COL3 LIKE 'C%'
UNION
SELECT * FROM TABLE1 WHERE COL1 like 'A%' AND COL2 LIKE 'B%' AND COL4 LIKE 'D%'

Any help would be appreciated.
Thanks.

Browse pgsql-general by date

  From Date Subject
Next Message Robert D. Nelson 2000-08-03 17:46:00 RE: Unions in views
Previous Message Roland Roberts 2000-08-03 17:36:01 Re: Re: [HACKERS] random() function produces wrong range