"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > And even then you better have a pretty high correlation on the first > column, otherwise you'll still get a seqscan.
Not with the LIMIT. (If he were fetching the whole table, very possibly the sort would be the right plan anyway.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq