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