Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E127C2E0257 for ; Sun, 9 Mar 2008 20:45:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 61665-01 for ; Sun, 9 Mar 2008 20:44:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.185]) by postgresql.org (Postfix) with ESMTP id 278332E0267 for ; Sun, 9 Mar 2008 20:45:02 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id g13so1091063rvb.43 for ; Sun, 09 Mar 2008 16:45:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=6YqgdgUCpq6FZ6eqjjO3M+/61Fy5NDnKmJVmM53j7gI=; b=v4N6Llks6FgJ4+CvToYJrZyAW8rlBdYbRmaY0pSEed+k6A0lT3X6Wtbdn4UDLTTOKw6hsDKiMtsRuucYPMShuPfAOqgm8tkZIHMqzn44VdGB7SHUGvZVa9pj59XME34ojoZ4X994/JfLq84VDApf6bo+0OnwQAIWuiMnQONKiP4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=qeZeIjJQyjuIsQGJV+CYtO0tBd6fZs7Ii5WykX+QdZ4KwZGFY6mQ7yELf3cKrfX6qxmq3w63MYAtq6TJxFEXaPH3iyCk+KOJpgaP4jpsYd+XOt9P7JvCSOn378w7I04p2HaZdCZmupOTzn1btUtxdX2UPJdBBFhQPGV6dXh6G58= Received: by 10.141.198.9 with SMTP id a9mr2631481rvq.280.1205106301195; Sun, 09 Mar 2008 16:45:01 -0700 (PDT) Received: from ?10.1.1.19? ( [203.217.18.65]) by mx.google.com with ESMTPS id m28sm18605358poh.7.2008.03.09.16.44.59 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 09 Mar 2008 16:45:00 -0700 (PDT) Message-ID: <47D475E9.1010709@gmail.com> Date: Mon, 10 Mar 2008 10:42:33 +1100 From: Chris User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: petchimuthu lingam CC: pgsql-php@postgresql.org Subject: Re: join query performance References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/4 X-Sequence-Number: 3829 petchimuthu lingam wrote: > > In a select query i have used the join conditions, will it affect query > performance. > > Explicitly I didn't used the join command, Will it make any difference. It'll make sure you don't miss any join conditions between two tables so it'll be helpful in that respect, I didn't read your whole query but with a 7 table join it's very easy to miss doing a match on one or more tables. It shouldn't take more than a couple of minutes to rewrite your query and find out the answers.. -- Postgresql & php tutorials http://www.designmagick.com/