B-tree Indexes in Databases Using SQLite and PostgreSQL as Examples

Vladimir will speak about the work of conventional™ indexes in databases and will tell: how the index speeds up the search; whether to index conditions where; whether to index conditions in order by; whether to index foreign keys; what to do if there are several search criteria; in what order to specify columns in the index; when the index is slow and how to reduce the impact of the index on the application.