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 ? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
