Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Indexes on Views

Re: Indexes on Views

From: Joe Celko <71062.1056_at_compuserve.com>
Date: 2000/04/24
Message-ID: <8e1l2q$hre$1@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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US