X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 08B71D1C90E for ; Sat, 26 Jul 2003 10:54:27 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 31557-05 for ; Sat, 26 Jul 2003 07:53:40 -0300 (ADT) Received: from ncc1701.cistron.net (uucp.cistron.nl [62.216.30.38]) by svr1.postgresql.org (Postfix) with ESMTP id B9A85D1C4DC for ; Sat, 26 Jul 2003 07:54:25 -0300 (ADT) Received: from news by ncc1701.cistron.net with local (Exim 3.35 #1 (Debian)) id 19gMh2-0008U6-00 for ; Sat, 26 Jul 2003 12:54:28 +0200 From: "HansH" Subject: Re: Wrong plan or what ? Date: Sat, 26 Jul 2003 12:53:23 +0200 Organization: Cistron Lines: 35 Message-ID: References: <00c101c35074$1e5f5b20$152aa8c0@GMENDOLA2> X-Trace: ncc1701.cistron.net 1059216867 32474 195.64.95.109 (26 Jul 2003 10:54:27 GMT) X-Complaints-To: abuse@cistron.nl X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/371 X-Sequence-Number: 9711 In response to "Mendola Gaetano": > I'm running Postgres7.3.3 and I'm performing this simple select: Looking at your fast three step plan > SELECT id_class from class_default where id_provider = 39; > SELECT id_user from user_data where id_class in ( 48 ); > SELECT * from user_logs where id_user in ( > 10943, 10942, 10934, 10927, 10910, 10909 ); I'ld stem for reordering the from and where clauses alike: select * from class_default cd, user_data ud, user_logs ul where cd.id_provider = 39 and ud.id_class = cd.id_class and ul.id_user = ud.id_user; Personally I dislike implied joins and rather go for _about_ this: select * from ( class_default cd LEFT JOIN user_data ud ON ud.id_class = cd.id_class ) LEFT JOIN user_logs ul ON ul.id_user = ud.id_user, where cd.id_provider = 39; Good luck, HansH