Have you ever deployed a new application that ran fine at first, then slowed to crawl as more and more data was added? Or tried to run a report that took minutes or even hours to come back? Database performance is a frequent bottleneck for many applications, and in this post you’ll learn about a critical aspect of database performance—indexes.
What Are Indexes?
An index is a linked copy of a subset of a table existing within the same database. It can consist of one or more columns (and it doesn’t have to include all of the rows). The index is linked to the table so when data is inserted, updated, or deleted in the table, it’s reflected in the index before the transaction is marked complete by the database. Indexes allow the query optimizer to use a subset of the table data.
The importance of indexes to database performance cannot be overstated. Frequently, one index can serve multiple queries and drastically improve the overall performance of a server. The SolarWinds database management portfolio, Database Insights for SQL Server, Database Performance Monitor (DPM), Database Performance Analyzer (DPA), and SQL Sentry, can help you with your monitoring and management needs.
Categories: Vendor Updates