Please run it with EXPLAIN ANALYZE and post the results. On Tue, Feb 10, 2004 at 02:30:57PM +0100, [EMAIL PROTECTED] wrote: > Hello all, > > I have the following query that has a problem i cannot resolve: > > SELECT puzzle_picking.*, tmagaztestate.mconto, tanagraficagen.araso, > tmagaztestate.mdabol, tcausalimagaz.tdescr > FROM tcausalimagaz RIGHT JOIN (tanagraficagen RIGHT JOIN (tmagazrighe LEFT JOIN > tmagaztestate ON (tmagazrighe.mnubol = tmagaztestate.mnubol) AND > (tmagazrighe.mspecie = tmagaztestate.mspecie) AND (tmagazrighe.manno = > tmagaztestate.manno) AND (tmagazrighe.mtiprk = tmagaztestate.mtiprk)) RIGHT JOIN > puzzle_picking ON (tmagazrighe.mriga = puzzle_picking.pkriga) AND > (tmagazrighe.mnubol = puzzle_picking.pknumbol) AND (tmagazrighe.mspecie = > puzzle_picking.pkspecie) AND (tmagazrighe.manno = puzzle_picking.pkanno) ON > tanagraficagen.aconto = tmagaztestate.mconto) ON tcausalimagaz.tcod = > tmagazrighe.mcaus > WHERE (((puzzle_picking.pkartcode)='5320009')) > ORDER BY puzzle_picking.pkdate; > > Basically it is very slow (20 secs to perform ), but if i change the right join of > tanagraficagen to an inner join it is instant (< than a second). My question is: > > Is it possible that a right join performs that much slower .. ? i mean i can > undertsand it takes more time .. but 20 sec is far too much .. > > What can i do to speed it up?? Keep in mind that i have indexes on all of the joined > columns and on the column in the where clause .. > > Thank you very much, > > Fabrizio Mazzoni > Macron Srl > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly
-- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > (... have gone from d-i being barely usable even by its developers > anywhere, to being about 20% done. Sweet. And the last 80% usually takes > 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce
pgp00000.pgp
Description: PGP signature