diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-06-23 21:16:29 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-06-23 21:16:29 +0000 |
| commit | 407bd1c29b66f7e007288455982f428e7f26b7f9 (patch) | |
| tree | 866df7c34223e10a00e6c2c9162e312682d554f5 /doc/src | |
| parent | aad4cc7d0dc4523bfc91613597f3c3c21aef8e00 (diff) | |
| download | postgresql-407bd1c29b66f7e007288455982f428e7f26b7f9.tar.gz postgresql-407bd1c29b66f7e007288455982f428e7f26b7f9.zip | |
Add MIN/MAX LIMIT/OFFSET mention.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 14 |
1 files changed, 11 insertions, 3 deletions
diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 08e9c9d98eb..b6de1a6d499 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -14,7 +14,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Thu Jun 20 22:00:57 EDT 2002</P> + <P>Last updated: Sun Jun 23 17:16:13 EDT 2002</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -923,7 +923,7 @@ Indexes are not automatically used by every query. Indexes are only used if the table is larger than a minimum size, and the query selects only a small percentage of the rows in the table. This is - because the random disk access caused by an index scan is sometimes + because the random disk access caused by an index scan can be slower than a straight read through the table, or sequential scan. <P>To determine if an index should be used, PostgreSQL must have @@ -940,7 +940,15 @@ usually faster than an index scan of a large table.</P> However, <SMALL>LIMIT</SMALL> combined with <SMALL>ORDER BY</SMALL> often will use an index because only a small portion of the table - is returned. + is returned. In fact, though MAX() and MIN() don't use indexes, + it is possible to retrieve such values using an index with ORDER BY + and LIMIT: +<PRE> + SELECT col + FROM tab + ORDER BY col + LIMIT 1 +</PRE> <P>When using wild-card operators such as <SMALL>LIKE</SMALL> or <I>~</I>, indexes can only be used if the beginning of the search |