Category: Indexes

This article explores the PostgreSQL implementation of the B-Tree and hash index data structures.
July 28, 2022 | Paul S. Randal | Indexes, PostgreSQL 0
Learn what indexes are, why they’re so important, and a bit of both the art and science of various indexing strategies.
August 31, 2021 | Paul S. Randal | Indexes 0
Query performance depends on database table indexes—learn why and see how index maintenance works.
August 26, 2021 | Frank Solomon | Indexes 0
Lee Walsh covers index fragmentation, several ways you can identify it, and why a more granular approach to index maintenance can save time and allow you to focus on other tasks during maintenance windows.
May 18, 2021 | Lee Walsh | SQL Sentry, Fragmentation, Indexes 0
Find out what's new in the latest version of SentryOne Plan Explorer.
May 12, 2020 | SentryOne | Plan Explorer, Indexes 0
Kevin Kline recaps his "SQL Server Indexing for Developers and Accidental DBAs" webinar and answers attendees questions with Sebastian Meine.
April 23, 2020 | Kevin Kline | SQL Server, Indexes 0
Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations.
March 26, 2020 | SQLPerformance.com | SQL Server, Indexes 0
Aaron Bertrand shows a simple way to keep your filtered indexes effective even under forced parameterization.
December 3, 2019 | SQLPerformance.com | SQL Server, Indexes 0
Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.
May 29, 2019 | SQLPerformance.com | SQL Server, Indexes 0
Glenn Berry goes over three different tactics you can use to squeeze some extra performance out of SQL Server without a lot of heavy lifting.
Following up on her post about automatic plan correction, Erin Stellato talks about a new feature in Azure SQL Database: Automatic Index Management.
Monica Rathburn (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems.
Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the cluste
Lori Edwards continues her series on SQL Server statistics, discussing some of the finer details around keeping stats up-to-date.
April 28, 2015 | Lori Edwards | Indexes, Statistics 1
Jason Hall shows us how table variables have changed in SQL Server 2014 and reminds us how helpful it can be to follow up on hard questions.
September 18, 2014 | Jason Hall | T-SQL, SQL Server, Indexes, Table Variables 4

Top Categories

See all
1 2

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More