What impact does my C/AL have on SQL - SIFT on 5.0 Sp1
http://dynamicsuser.net/blogs/waldo/archive/2008/08/01/what-impact-does-my-c-al-have-on-sql-sift-on-5-0-sp1.aspx
The article above referenced in:
SIFT on SQL in 5.0 SP1
www.mibuso.com/forum/viewtopic.php?f=34&t=13154&view=next
More info:
Indexed views work best for queries that aggregate many rows.
How to Create Indexed Views
(https://sqlship.wordpress.com/2010/04/13/how-to-create-indexed-views/)
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 view (http://en.wikipedia.org/wiki/Materialized_view)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment