Search Postgresql Archives

Which query is good - IN or OR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



A simple query I can write in any of the following two ways:

1. 
Select col1
from table
where col2 in ('A','B');

2.
Select col1
from table
where
 col2 = 'A'
or  col2 = 'B'

Here IN condition may be more than two.
I need to know which one is good for good performance.

Any idea please.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux