X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E83D5280A for ; Tue, 24 May 2005 05:47:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70224-09 for ; Tue, 24 May 2005 08:46:59 +0000 (GMT) Received: from pc7.berlin.powerweb.de (pc7.berlin.powerweb.de [62.67.228.13]) by svr1.postgresql.org (Postfix) with ESMTP id 32E9E528A7 for ; Tue, 24 May 2005 05:46:57 -0300 (ADT) Received: from spock (pD9ED0646.dip0.t-ipconnect.de [217.237.6.70]) by pc7.berlin.powerweb.de (8.9.3p3/8.9.3) with SMTP id KAA12677 for ; Tue, 24 May 2005 10:46:57 +0200 Message-ID: <005b01c5603d$7163bac0$6602a8c0@spock.nostromo> From: "Harald Lau (Sector-X)" To: References: <20050524064034.18213.qmail@web53105.mail.yahoo.com> Subject: Re: Select performance vs. mssql Date: Tue, 24 May 2005 10:49:05 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/357 X-Sequence-Number: 12521 Mark, > MSSQL Machine: > That "Explain Analyze" command doesn't work for MSSQL, try this: set showplan_all on go select ... go Harald