
Talk
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.