X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 12CEFD1DF71 for ; Thu, 11 Dec 2003 16:00:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 59848-08 for ; Thu, 11 Dec 2003 12:00:21 -0400 (AST) Received: from hotmail.com (bay7-f88.bay7.hotmail.com [64.4.11.88]) by svr1.postgresql.org (Postfix) with ESMTP id B625AD1DF95 for ; Thu, 11 Dec 2003 12:00:20 -0400 (AST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 11 Dec 2003 08:00:19 -0800 Received: from 200.24.104.55 by by7fd.bay7.hotmail.msn.com with HTTP; Thu, 11 Dec 2003 16:00:19 GMT X-Originating-IP: [200.24.104.55] X-Originating-Email: [mileruiz@hotmail.com] X-Sender: mileruiz@hotmail.com From: "sandra ruiz" To: pgsql-performance@postgresql.org Subject: hints in Postgres? Date: Thu, 11 Dec 2003 11:00:19 -0500 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 11 Dec 2003 16:00:19.0890 (UTC) FILETIME=[E066B920:01C3BFFF] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/179 X-Sequence-Number: 5039 Hi list, I need to know if there is anything like hints of Oracle in Postgres..otherwise..I wish to find a way to force a query plan to use the indexes or tell the optimizer things like "optimize based in statistics", "I want to define the order of the a join" , "optimize based on a execution plan that I consider the best" ... thanks. _________________________________________________________________ Las mejores tiendas, los precios mas bajos, entregas en todo el mundo, YupiMSN Compras: http://latam.msn.com/compras/