June 9, 2005 at 3:30 am
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
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
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