does LIMIT save time?

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: does LIMIT save time?
Date: 1999-08-19 13:17:46
Message-ID: 14268.1018.192099.531387@blanc.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-08-19 13:18:33 Re: [SQL] Counting the number of distinct rows returned
Previous Message Tom Lane 1999-08-19 13:16:30 Re: [SQL] Problems using count() with a join