does LIMIT save time? - Mailing list pgsql-sql

From Dirk Lutzebaeck
Subject does LIMIT save time?
Date
Msg-id 14268.1018.192099.531387@blanc.aeccom.com
Whole thread Raw
Responses Re: [SQL] does LIMIT save time?  (wieck@debis.com (Jan Wieck))
List pgsql-sql
Hi,

is using SELECT LIMIT faster than using SELECT without LIMIT on
the same query? If yes, in what way? What is if I use ORDER in the
SELECT clause?

Is it possible to get the *total* number of rows selected (ie. doing
the query virtually without LIMIT) when using a LIMIT clause?

Thanks for help,

Dirk


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Problems using count() with a join
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Counting the number of distinct rows returned