Received: from k2.aeccom.com (IDENT:root@gate1.aeccom.com [193.158.11.51]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA26639 for ; Thu, 19 Aug 1999 09:17:49 -0400 (EDT) (envelope-from lutzeb@aeccom.com) Received: from blanc.aeccom.com (IDENT:lutzeb@blanc.aeccom.com [192.168.0.10]) by k2.aeccom.com (8.9.3/8.9.3) with ESMTP id PAA07075; Thu, 19 Aug 1999 15:17:47 +0200 Received: (from lutzeb@localhost) by blanc.aeccom.com (8.8.7/8.8.7) id PAA09501; Thu, 19 Aug 1999 15:17:46 +0200 From: Dirk Lutzebaeck MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <14268.1018.192099.531387@blanc.aeccom.com> Date: Thu, 19 Aug 1999 15:17:46 +0200 (CEST) To: pgsql-sql@postgreSQL.org Subject: does LIMIT save time? X-Mailer: VM 6.71 under 21.1 (patch 4) "Arches" XEmacs Lucid 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