Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Jean Bulinckx

SQLServerCentral.com profile

   Items 1 to 1 of 1   
 

Indexed Views With Outer Joins

SQL Server 2000 has indexed views, which can greatly improve database performance. However there are a number of restrictions on building the view, including the restriction against outer joins. So how can this work? New author Jean Charles Bulinckx brings us a technique that can help you get around this restriction.   Read more...
By Jean Bulinckx 2005/05/19 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 13,394 reads
   Items 1 to 1 of 1