--- Reece Hart <reece@xxxxxxxxx> wrote: > I believe that you're mistaken, and you can see it rather easily by > explaining a select on a view (or even a view of views). For example: > View definition: > SELECT pa.palias_id, pv.pseq_id, pa.origin_id, pa.alias, > pa.descr, pa.tax_id, pv.ref_pseq_id, pv.added > FROM paliasorigin pa, pseqalias pv > WHERE pv.palias_id = pa.palias_id AND pv.is_current = true; if you're only selectivity is "is_current = true", you will get a seq. scan no matter what. However, I bet your explain plan would be much better if you added something like: SELECT * FROM View WHERE origin_id = <some origin_id value>; as long as you had an index on origin_id. Regards, Richard Broersma Jr.
