MySQL Create Index Guide: How to Add and Optimize Indexes for Performance
Have you thought of how big a deal is to create an index in MySQL? Using it enough vs. not...
SQL Server Resumable Index: Is it good for you?
SQL 2017 introduced the ability to pause and resume index rebuild operations during database maintenance. This feature offers more...
A Simple Use Case for Indexes on Primary Keys
Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Hash What? Understanding Hash Indexes
Hash indexes are an integral part of databases. If you’ve ever used a database, chances are...
Easy Answers to 5 Vital Questions about Composite Index in SQL
Imagine you need to query a table with a WHERE clause on columns a, b, and c. Sometimes, you filter the results with columns a and b only....
Clustered and Non Clustered Index: 7 Top Points Explained
Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what does it mean and where should you apply...
3 Methods to Rebuild All Indexes for All Tables with T-SQL in SQL Server Database
There are several methods of how to rebuild all indexes of all tables in SQL Server, among them:...
SQL Server: Renaming Indexes using the sp_rename Procedure
Not so long ago, I was working on a project where we needed to change the data type of a table. The table had millions of rows, and we...
22 Different T-SQL Indexes Examples to Warp Speed Your Queries
Indexing the database tables is one of the ways to up your game in tuning queries. How do you do it? Today’s post will give you 22 SQL...
Virtual Columns and Functional Indexes
Much too often, we see poorly written complex SQL queries running against the database tables. Such...
