Rebuild indexes and update statistics without a maintenance plan

Products

• IT Management Suite

Issue/Introduction

 Is it possible to rebuild indexes and update statistics without a maintenance plan?

Environment

ITMS 8.x

Resolution

This can be done with the following:

1. Run the attached SQL query
2. Copy the columns "Index Script" and "Update Statistics Script" into another SQL query window
3. Run the created SQL scripts

 

Additional Information

178476 SQL Server Implementation Best Practices and Performance Tuning

18814 Creating a maintenance plan in SQL Server 2012 or later to optimize database performance

158633 SQL Maintenance script for the Symantec Management Platform database