Владимир Ситников — B-tree индексы в базах данных на примере .NET Entity Framework и PostgreSQL

Description:

This talk explains how standard indexes work in databases, covering topics such as how indexes speed up searches, when to index WHERE clauses, ORDER BY clauses, and foreign keys, how to handle multiple search criteria, the order of columns in an index, and situations where indexes can slow down performance and how to reduce their impact. It is useful for both newcomers and seasoned developers.