Topic
Indices
All content about Indices — 3 results.
Indices
Tutorial
How to diagnose a specific slow SQL query in your MU Online server's database
Find and fix the specific query that's choking your MU Online server's database, using execution plans, indexes, and SQL Server's Profiler/Extended Events.
16 min · Advanced ·
Tutorial
Composite indexes for MU Online databases: how to kill slow queries
Diagnose and fix slow queries in your MU Online server database with well-designed composite indexes, from EXPLAIN plans to continuous performance monitoring.
15 min · Advanced ·
Tutorial
How to configure indexes and database maintenance on MU Online
Create the right indexes on the MuOnline tables and set up a maintenance routine (rebuild, reorganize, update statistics) so the database stays fast even with the server packed for months.
23 min · Advanced ·