Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 958162E02BD for ; Fri, 7 Mar 2008 00:18:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05729-04 for ; Fri, 7 Mar 2008 00:18:45 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.236]) by postgresql.org (Postfix) with ESMTP id 700EE2E0272 for ; Fri, 7 Mar 2008 00:18:45 -0400 (AST) Received: by qb-out-0506.google.com with SMTP id o12so139409qba.17 for ; Thu, 06 Mar 2008 20:18:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=lpMzjnkkQudexOVubsYmd/i9NgI1n7p+MC/veHODiNc=; b=F8d/fJkFmrWPYWdc9xn1TR7ZwR28Lm52dSIk0L89Ssonzq/ogmApfHd4srOZmWU77FWroI/gAmi0rw6N6/W9apRdxt8zaib8RiBEznz37+iRlnuKezI7lEPNsQcmG6gMElNBc99U3Fwi4/U+LqHB9tV5GJjDYaMkT5XoFv1NryA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=CkdEzK6RXOMRbDakrA9RevixwFBfDhzpyLlZAGWbM4QpRyLnk/UjxQoOtGcvDcrX5vnMfequ0htcl0+DM6PDJJA6tSGY4WlIAD05AoGYZF5YS3tt331OAD/naNa9TCzll+Ihd8r4hBXADqAPMY53Wokc4Yug8IIlCgbC5ds2ulg= Received: by 10.114.88.1 with SMTP id l1mr1296225wab.79.1204863524117; Thu, 06 Mar 2008 20:18:44 -0800 (PST) Received: by 10.114.208.18 with HTTP; Thu, 6 Mar 2008 20:18:44 -0800 (PST) Message-ID: Date: Fri, 7 Mar 2008 09:48:44 +0530 From: "petchimuthu lingam" To: pgsql-php@postgresql.org Subject: will foreign key improve select query performance MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3987_2167580.1204863524026" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200803/1 X-Sequence-Number: 3826 ------=_Part_3987_2167580.1204863524026 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline If i create foreign key references, whether it will improve the performance in the select query? -- With Best Regards, Petchimuthulingam S ------=_Part_3987_2167580.1204863524026 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline If i create foreign key references, whether it will improve the performance in the select query?


--
With Best Regards,
Petchimuthulingam S ------=_Part_3987_2167580.1204863524026--