Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] does LIMIT save time? - Mailing list pgsql-sql

From Dirk Lutzebaeck
Subject Re: [SQL] does LIMIT save time?
Date
Msg-id 14269.3615.579004.633506@blanc.aeccom.com
Whole thread Raw
In response to Re: [SQL] does LIMIT save time?  (wieck@debis.com (Jan Wieck))
List pgsql-sql
Tree view 
Jan Wieck writes:
>     So in general, LIMIT itself could never hurt.  ORDER can  but>     someone  who  cares  for  speed  is normally
willingto setup>     appropriate multi key indices to prevent sort steps.
 

Just to know, how can I prevent sorting by using multi key indices?


Thanks for your elaborte answer,

Dirk

pgsql-sql by date:

Previous
From: "Esteban Chiner Sanz"
Date:
Subject: Re: [SQL] What JDBC datatype can be used for DATETIME ?
Next
From: Eric Enockson
Date:
Subject: generate random unique object id