Updating a view
We recommend against specifying 0 PERCENT or 0 ROWS.When 0 PERCENT or ROWS is specified, the statistics object is updated but does not contain statistics data.By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently than the default updates.Updating statistics ensures that queries compile with up-to-date statistics.
SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation.To control the update behavior of the views in an active drawing, specify the Automatic view update mode.If selected, drawing views update as you change the model.For more information about AUTO_CREATE_STATISTICS, see ALTER DATABASE SET Options (Transact-SQL).
To view all indexes for a table or view, you can use sp_helpindex.Revit 2014, Revit 2015, Revit 2016, Revit 2017, Revit Architecture 2014, Revit Architecture 2015, Revit Architecture 2016, Revit MEP 2014, Revit MEP 2015, Revit MEP 2016, Revit Structure 2014, Revit Structure 2015, Revit Structure 2016, Vault Professional 2014, Vault Professional 2015, Vault Professional 2016, Vault Professional 2017, & Vault Workgroup 2014 This is caused by insufficient user permissions on the Vault folder where the files reside or the lifecycle state they exist in. In the Vault's vlog this error appears: Exception: Permission Denied  Stacktrace: Server stack trace: em Connectivity. Starting with SQL Server 2016 (13.x), sampling of data to build statistics is done in parallel, when using compatibility level 130, to improve the performance of statistics collection.