Re: Indexes on Views
From: Joe Celko <71062.1056_at_compuserve.com>
Date: 2000/04/24
Message-ID: <8e1l2q$hre$1_at_nnrp1.deja.com>#1/1
Date: 2000/04/24
Message-ID: <8e1l2q$hre$1_at_nnrp1.deja.com>#1/1
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.
--CELKO--
Joe Celko, SQL and Database Consultant
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Apr 24 2000 - 00:00:00 CEST