Discussion Board

Indexed views The above statement is true Indexed views 06-9-2017 07:45 AM

Indexed views The above statement is true. Indexed views work best when the underlying data are infrequently updated. The maintenance of an indexed view can be greater than the cost of maintaining a table index. If the underlying data is updated frequently, the cost of maintaining the indexed view data may outweigh the performance benefits of using the indexed view. If the underlying data is updated periodically in batches but treated primarily as read-only between updates, consider dropping any indexed views before updating, and rebuilding them afterward. Doing this may improve performance of the updates. Prajakta Pandit 03-8-2017 10:59 PM

Write your comments

*

* Email must be in the form someone@domain.com

*

*