Updating a view in sql server 2016
Before going too deep in the type of execution plans and the Live Execution Plan new feature which is the main focus of our article here, let’s briefly describe how SQL Server queries are executed.
When a SQL query is submitted, the query syntax will be checked, to make sure that it is written in the correct format, in a process called Query Parsing.
In order to trigger the auto update statistics feature in SQL Server, the number of updated rows should exceed 20% of the table rows.
In the case of large tables, such as a table with 1 million rows, more than 200,000 records need to be updated in order to update the table statistics.
The fields in a view are fields from one or more real tables in the database.
SQL Server Management Studio a graphical interactive that allows you to interact with the databases hosted on your servers.
SSMS provides you with the ability to write, edit, execute, analyze and monitor your SQL queries.
SQL Server 2016 introduces a new feature that allows you to view the Live Execution Statistics for your active query, showing the run-time execution statistics for each execution plan operator such as the number of rows, the time required by each operator and the operator and overall execution progress, without waiting for the query execution to finish.
It allows you to track the data flow between the operators in real time one by one till the query execution completed.