Post reply

materialized views equivalent ?

  • October 27, 2004 at 9:44 am

    #361378

    Hi,

    Oracle query :

    create materialized view view1 as select *from test

    Is there any equivalent for the above query in SQL Server (specifically for "materialized views")

    Please advice,

    Thanks,

    ShivSam

  • October 27, 2004 at 9:50 am

    #528183

    Yes, look up Indexed Views in Books Online.

    You'll want to keep in mind that Indexed Views were designed mostly to assist with aggregate queries, not flat/non-aggregate queries (some people try to use them to get rid of JOINs and are quickly disappointed when they discover that performance isn't that much better -- but with aggregates, performance can be better by several orders of magnitude).

    --
    Adam Machanic
    whoisactive

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply