How to Think Like the SQL Server and PostgreSQL Engines

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In my new totally free How to Think Like the Engines class, you’ll learn how the SQL Server and Postgres database engines look at your indexes and build your query results. You’ll learn: The differences between nonclustered indexes and clustered indexes (and why Postgres doesn't use clustered indexes at all) Which kinds of indexes work better as a starting point for SQL Server, versus which ones work better for Postgres The basics of execution plans on both platforms, and how to read them