Re: [PERFORM] partial index + select query performance

2008-03-13 Thread A. Kretschmer
am Thu, dem 13.03.2008, um 12:51:54 +0530 mailte petchimuthu lingam folgendes: > > I have created partial index on a field with conditions, if field _a > 200 > and field_a < 300. > > I using the select query with condition as field_a in ( 100, 250, 289, ), > > Will it use the index. Why do

[PERFORM] partial index + select query performance

2008-03-13 Thread petchimuthu lingam
I have created partial index on a field with conditions, if field _a > 200 and field_a < 300. I using the select query with condition as field_a in ( 100, 250, 289, ), Will it use the index. -- With Best Regards, Petchimuthulingam S