Indexes: Flashcards Review

Flashcards Review

Use these flashcards to review the key ideas from the Indexes chapter before you take the assessment. Each card shows a term or question on the front and a short answer on the back. Try to answer first, then flip to check. The deck covers what an index is and why we use it, how indexes speed up reads and slow down writes, selectivity and table scans, when an index is not worth it, and the main index types: primary, unique, clustered, non-clustered, composite, full-text, and hash.