Post reply

Materialized Views

  • June 9, 2005 at 3:30 am

    #109730

    Hi,

    I have  Materialized Views in Oracle .

    The execution of the output in front end is faster.

    I would like to know : How can this be established the same in SQL Server for fast display.

     

     

     

     

     

  • June 9, 2005 at 5:23 am

    #564146

    According to the article an MView: is A materialized view is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots.

    Why not just create a table and store your data in there?  You can schedule this to run at certain times and query off the summarized data table.



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • June 9, 2005 at 6:35 am

    #564163

    You could also look into Indexed Views. Depending on the indexes you put on the view, you could end up with something close.

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

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