Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 196E89FB614 for ; Sat, 28 Jul 2007 16:27:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37438-04 for ; Sat, 28 Jul 2007 16:27:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hm32.locaweb.com.br (hm32-3.locaweb.com.br [200.234.205.225]) by postgresql.org (Postfix) with SMTP id 1ACF19FB5FF for ; Sat, 28 Jul 2007 16:27:18 -0300 (ADT) Received: (qmail 16901 invoked from network); 28 Jul 2007 19:27:16 -0000 Received: from unknown (10.1.10.142) by hm32.locaweb.com.br with QMQP; 28 Jul 2007 19:27:16 -0000 Received: from unknown (HELO brunolaptop) (bruno@ravnus.com@201.19.204.108) by hm456.locaweb.com.br with SMTP; 28 Jul 2007 19:27:30 -0000 From: "Bruno Rodrigues Siqueira" To: Subject: select on 1milion register = 6s Date: Sat, 28 Jul 2007 16:27:14 -0300 Message-ID: <000c01c7d14d$4df223f0$e900a8c0@brunolaptop> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01C7D134.28A4EBF0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcfRTU06g9HEFDikS/WMCrHIf6v0DQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.248 tagged_above=0 required=5 tests=AWL=2.248, BAYES_80=2, HTML_MESSAGE=0.001 X-Spam-Level: **** X-Archive-Number: 200707/398 X-Sequence-Number: 26082 This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C7D134.28A4EBF0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Friends, Who can help me? My SELECT in a base with 1 milion register, using expression index = 6seconds. Please, I don't know how to makes it better. Thanks ------=_NextPart_000_000D_01C7D134.28A4EBF0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Friends,

= Who can help = me? My SELECT in a base with 1 milion register, using expression index =3D = 6seconds…

Please, I don’t know how to makes = it better.

Thanks

------=_NextPart_000_000D_01C7D134.28A4EBF0--