From dcdf738abb013082294b9a8afb15b8405e042d47 Mon Sep 17 00:00:00 2001
From: Bruce Momjian Last updated: Thu Apr 13 08:14:25 EDT 2006 Last updated: Thu Apr 13 08:20:04 EDT 2006 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -361,7 +361,7 @@
Frequently Asked Questions (FAQ) for PostgreSQL
-
Indexes are normally not used for ORDER BY or to perform joins. A sequential scan followed by an explicit sort is - usually faster than an index scan of a large table.
+ usually faster than an index scan of a large table. However, LIMIT combined with ORDER BY often will use an index because only a small portion of the table is returned. -- cgit v1.2.3