Re: Views- Advantages and Disadvantages

--- Reece Hart <reece(at)harts(dot)net> 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.