From 227a584655edcf16e98d0f986fbda0c4abd6b991 Mon Sep 17 00:00:00 2001
From: Bruce Momjian Last updated: Wed May 30 18:57:52 EDT 2001 Last updated: Wed May 30 19:00:33 EDT 2001 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) Indexes are usually not used for ORDER BY
- or joins: a sequential scan followed by an explicit sort is
- faster than an indexscan of all tuples of a large table, because it
- takes fewer disk accesses.Frequently Asked Questions (FAQ) for PostgreSQL
-
@@ -908,9 +908,9 @@ Maximum number of indexes on a table? unlimited
periodically.
When using wild-card operators such as LIKE or ~, indices can only be used if the beginning of the search -- cgit v1.2.3