Re: [PERFORM] Performance difference between IN(...) and ANY(...) operator

2009-07-23 Thread Robert Haas
On Wed, Jul 8, 2009 at 2:50 AM, Gnanam wrote: > I'm using both IN and ANY() operators extensively my application.  Can > anybody answer me on the following questions: >        1) Which operator is advantage over the another, interms of > performance? >        2) If I've indexed these columns, will

[PERFORM] Performance difference between IN(...) and ANY(...) operator

2009-07-14 Thread Gnanam
Hi, I'm using both IN and ANY() operators extensively my application. Can anybody answer me on the following questions: 1) Which operator is advantage over the another, interms of performance? 2) If I've indexed these columns, will both the operators make use of index scanning?