How to update statistics for a database's system tables

We recently upgraded many of our instances to 2016. As a result, a SELECT statement from sqlpackage.exe is timing out on some instances.

After some testing, I found that by updating the statistics on the database's system tables showing up in the execution plan, the SELECT stopped timing out.

update statistics sys.[sysclsobjs] with fullscan update statistics sys.[syscolpars] with fullscan update statistics sys.[sysidxstats] with fullscan update statistics sys.[sysiscols] with fullscan update statistics sys.[sysobjvalues] with fullscan 

Is there anyway either through the standard maintenance packages, Ola Hallengren's scripts or some other process to only update system table statistics?

Replay

Category: execution plan Time: 2016-07-29 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.132 (s). 12 q(s)