A database index is an auxiliary structure, often a B-tree, that lets the database find rows without scanning the whole table, speeding reads at the cost of storage and slower writes.
Database indexing - Interview Concepts - ExtraBrain is part of ExtraBrain's local-first Mac workflow for live interviews, meetings, transcription, provider control, and responsible AI use.
A database index is an auxiliary structure, often a B-tree, that lets the database find rows without scanning the whole table, speeding reads at the cost of storage and slower writes.
ExtraBrain has 1 current public platform family, macOS, with support for 2 Mac CPU families: Apple Silicon and Intel.
ExtraBrain has 3 configurable data paths to review before sensitive work: local Parakeet transcription, local Gemma 4 where installed and compatible, and external providers you choose.
They turn full-table scans into fast lookups for filters, joins, and sorts on indexed columns.
Each index adds storage and must be updated on writes, so unnecessary indexes slow inserts and updates.
Composite and covering indexes match query patterns; column order and selectivity matter.
Use any live AI assistant only where interview, workplace, school, and platform rules allow it. Do not use generated answers to misrepresent your skills, experience, or authorship.
Short answers for people and crawlers comparing ExtraBrain with other live AI assistants.
Add indexes for columns frequently used in filters, joins, and sorts, guided by query plans and selectivity.
Indexes consume storage and slow writes, so avoid indexing columns that queries rarely use.
