On 29 Oct 2002, Ives Landrieu wrote: > Hi, > > Can anybody explain the following results when using EXPLAIN, > one time with enable_seqscan=on and one time with enable_seqscan=off. > What I don't understand is that the nodes created are the same > (index scan, seq scan), but the costs differ.
Enable seq scan actually just sets a large cost disbenefit to seq scans. Is alias96.STATUS indexed? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html