Rebuilding SQL Server Indexes
Article ID: KB0078154
Updated On:
| Products | Versions |
|---|---|
| TIBCO Scribe Insight | 7.9.1 |
Description
Whether you are using SQL server as a data source, target database, or to store the ScribeInternalDB for TIBCO Scribe Insight, you may notice a degradation of performance over time. This can be in indication that the indexes for the database tables are fragmented. TIBCO Scribe does not provide a utility to rebuild SQL indexes, however there are many available on the internet. For example, the link below provides a script and instructions for rebuilding your indexes.
SQL Server Script To Rebuild All Indexes For All Tables And All Databases
SQL Server Script To Rebuild All Indexes For All Tables And All Databases
Issue/Introduction
If you notice a degradation in performance when using SQL Server, you may need to rebuild the indexes for the database tables.
Environment
TIBCO Scribe Insight
Feedback
Yes
No
Powered by
