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.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sat Feb 07 2004 - 05:08:26 CST
