On Sat, 7 Feb 2004, niall.litchfield_at_dial.pipex.com wrote:
> note below
> "Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message
> news:3hb920dp1gb3lvphn0363vv8jatgi4c3bv_at_4ax.com...
>> >* Can columns on a VIEW be indexed?
>> Only tables can be indexed
>
> You can define a database object called a materialized view (or
> snapshot) which can be indexed, this object is analagous to
> (but more flexible than IMO) indexed views in MSSQL.
I always started my descriptions of materialized views as fancy
indexes, but one can't index an index so I guess that really
isn't a good description.
--
Galen Boyer
Received on Sat Feb 07 2004 - 16:37:08 CST
