Am Donnerstag, 29. September 2005 21:44 schrieb Sergei Dubov: > select * from table_a where table_b_id=1, > > will the query use an index? Will this be true when I do join on this > table?
It could use the index, but whether it will depends on the particular data distribution. The EXPLAIN command is your friend. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
