Siirry sisältöön
Global sound
Data Engineering Concepts

Data Engineering Concepts

Database Indexes: How They Work and their Main Types

· 25 min · Jakso 2

Jakson kuvaus

Database indexes are one of the most important tools for improving query performance - but there are many different types, and the differences between them are not always obvious.
In this episode, I explain how indexes work, what's their benefits and drawbacks, and I go through the main index types and concepts: B-tree and B+ tree indexes, dense and sparse indexes, bitmap and hash indexes, clustered and non-clustered indexes, composite and covering indexes, as well as duplicate and redundant indexes.
There also details about why column order matters in composite indexes and how an index-only…

Sivusto: podcasters.spotify.com

Livenä, viimeisin tunti: 13 883 kappaletta 7 266 asemalla 143 maassa

Löydä maailma radion kautta

Lisää tapoja löytää (7)

Kuulitko jotain hyvää? Tallenna se tai avaa se suoraan Spotifyssa.

★ Artist of the week The fastest riser on the radio this week
Your song here? From € 9 per week →
Radio 538 luisteren - Live!Suosittua nyt