[GENERAL] Join faster than single table query

Hi: I must have missed something, but how is it possible that a join on tables A and B is faster (a lot faster) than a query to one of the tables with the same conditions? The problem seems to be with the query plan, in the case os a query to table_a only, the planner executes a "Seq Scan", in

Re: [GENERAL] Join faster than single table query

Hi Martijn: Thanks for your answer, I really missed something ;-) Kind regards, Ruben. Martijn van Oosterhout wrote: On Mon, Aug 11, 2003 at 01:48:21PM +0200, ruben wrote: Hi: I must have missed something, but how is it possible that a join on tables A and B is faster (a lot faster) than a

Re: [GENERAL] Join faster than single table query

On Mon, Aug 11, 2003 at 01:48:21PM +0200, ruben wrote: > Hi: > > I must have missed something, but how is it possible that a join on > tables A and B is faster (a lot faster) than a query to one of the > tables with the same conditions? > > The problem seems to be with the query plan, in the ca