Chapter Assessment

You have reached the end of the Indexes chapter. Check your understanding of database indexes: what an index is, how it speeds up reads while slowing writes, selectivity and table scans, how a B-tree stays shallow and what a page split costs, the index types including primary, unique, clustered, non-clustered, composite, covering, partial, bitmap, full-text, hash and geospatial, the difference between B-tree and LSM storage engines, and how secondary indexes behave once data is sharded

.....

Like the course? Get enrolled and start learning!