This article explores the PostgreSQL implementation of the B-Tree and hash index data structures.
Category: Indexes
Learn what indexes are, why they’re so important, and a bit of both the art and science of various indexing strategies.
Query performance depends on database table indexes—learn why and see how index maintenance works.
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.
Find out what's new in the latest version of SentryOne Plan Explorer.
Kevin Kline recaps his "SQL Server Indexing for Developers and Accidental DBAs" webinar and answers attendees questions with Sebastian Meine.
Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations.
Aaron Bertrand shows a simple way to keep your filtered indexes effective even under forced parameterization.
Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.
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.
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.
