Indexes – Contrast & Compare PostgreSQL to SQL Server

Kevin Kline

Skilled SQL Server data professionals know that SQL Server and Azure SQL uses only one structure for row store indexes, the B-tree+ index structure. This structure is easy to understand and provides consistently good performance. However, the most popular open-source relational database, PostgreSQL, provides a variety of alternative indexes and index structures that can trip up an SQL Server pro attempting to migrate between the data platforms. Join this session to compare and contrast the index structure and behaviors on these two popular and widespread database platforms.