On Tue, 03 Aug 2004 06:50:46 -0600, Martin Gainty wrote: > > Keep in mind that when you use LIKE you will NOT use an index but you will > use a full table scan instead > Also instead of using IN EXISTS uses Indexes on the master table query..if > you have master-heavy or parent-heavy query use EXISTS/NOT EXISTS vs IN/NOT > IN > > http://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php
The behaviour of previous PostgreSQL versions that lacked some of the current planner optimizations (currently IN is equally if not better optimized as EXISTS in PostgreSQL) seems to have little relevance for the issue at hand. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]