1. Why are indexes so important in relational databases?
Relational joins require the system to find and match values across the tables. Indexes, particularly on the key columns, make this process substantially faster.