From 032858216caa0e820ddfe32ec4cd91a2de31a6b4 Mon Sep 17 00:00:00 2001
From: Bruce Momjian Last updated: Sun Feb 12 12:15:49 EST 2006 Last updated: Fri Feb 24 09:59:35 EST 2006 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -742,16 +742,8 @@ table?Frequently Asked Questions (FAQ) for PostgreSQL
- unlimited
usually faster than an index scan of a large table.
- SELECT col - FROM tab - ORDER BY col [ DESC ] - LIMIT 1; -- + is returned. +
If you believe the optimizer is incorrect in choosing a
sequential scan, use SET enable_seqscan TO 'off'
and
run query again to see if an index scan is indeed faster.