Listmail wrote: > > Followup to my previous test, with an index this time > > EXPLAIN ANALYZE SELECT * FROM test WHERE value IN ( 1000 integers )
I'm not quite sure what you're trying to measure here, but I don't think it is what was suggested. IIRC the suggestion was to move the values from your IN (...) operator into a temp table and join against that. Try measuring something like this: EXPLAIN ANALYZE SELECT * FROM table JOIN test ON (table.column = test.value) vs. EXPLAIN ANALYZE SELECT * FROM table WHERE value IN ( 1000 integers ) -- Alban Hertroys [EMAIL PROTECTED] magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World // ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
