October 23, 2001 at 8:05 am
Can we write materialized views in the MS SQL Server 6.5? If yes please give the syntax. If no, please tell me, is there any alternate way?
October 24, 2001 at 6:24 am
Not simply. You would have to write the triggers to maintain the view (table).
Andy
October 24, 2001 at 10:19 am
You would have to do as Andy said and duplicate data in a separate table.
You can index views (very similar) in SQL 2000.
Steve Jones
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy