On Sun, Nov 2, 2008 at 6:39 PM, Stephen Frost <[EMAIL PROTECTED]> wrote: > Simon, > >> * Higher overhead mapping to original tables and indexes > > This just plain isn't true in PG, at least, and I'd think most other > sensible databases..
Note that, at least in older versions, MySQL completely materialized a temporary table from a view, then used that for the view. This is horribly inefficient, and results in a lot of people thinking views are slow. Not sure if this has been addressed in MySQL yet, don't really care anymore, since I rarely use mysql for anything anymore. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general