> > This is maybe a newbie question, but what is the difference with a
> > materialized view ?
>
> An updateable view is one you can insert, delete or update rows.
> A materialized view is one that is pre-executed... i mean, that the
> data is stored in a file for fast execution of the view
Thanks Jaime, it's perfectly clear now.
David
--
[EMAIL PROTECTED] - tel: 01.46.47.21.33 - fax: 01.46.47.21.37
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
