Re: Views- Advantages and Disadvantages

--- Reece Hart <reece@harts.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.