Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 44207475451
	for <pgsql-sql@postgresql.org>; Thu, 18 Jul 2002 06:26:29 -0400 (EDT)
Received: by news.hub.org (Postfix, from userid 8)
	id 66D4F382451; Thu, 18 Jul 2002 06:25:51 -0400 (EDT)
From: <adrian@wsi.edu.pl>
X-Newsgroups: comp.databases.postgresql.sql
Subject: hints or suggestion for optimizer
Date: Thu, 18 Jul 2002 12:34:27 +0200
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 21
Message-ID: <ah653f$130v$1@news.hub.org>
X-Complaints-To: news@hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
To: pgsql-sql@postgresql.org
X-Archive-Number: 200207/280
X-Sequence-Number: 8658

How can I optimize Postrges SQL when I would like have ordering kolumns
without clause ORDER BY - in Oracle you can use hints to suggestion
optimizer.

for example.

SELECT /*+   INDEX_ASC TAB(TAB_PK)  +/   * FROM TAB <WHERE CLAUSE> -  most
efficent

SELECT * FROM TAB ORDER BY TAB_PK <WHERE CLAUSE>

where TAB_PK - is unique index on KOD column

WHERE CLAUSE - without OR ,UNION,  accept LIKE, AND etc

Does similar mechanizm has Postgres ?