Hi all, I've got a query with a long (>50) list of ORs, like the following:
SELECT colB, colC FROM table WHERE colA=X OR colA=Y OR colA=Z OR .... Is there any difference in how postgresql manages the above query and the following one? SELECT colB, colC FROM table WHERE colA IN (X,Y,Z,...) Which is the suggested index to use on colA to get better performances? Thanks, Luca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
