Re: Indexes on Views

As an aside, there is an INSTEAD OF trigger in SQL Server 2000 that
amkes VIEWs much more powerful. This is an SQL-92 feature which has
not be widely implemented. The idea is that instead of trying to
update the VIEW to which the trigger is attached, you excute a block of
code which can then reference the underlying base tables. The user
never knows that he was looking at a VIEW.