Database Management Systems·Indexing & Storage·FoundationWhat does an index do?A table has a million rows. You add an index on the email column.What changes?AEverything gets faster, since the table is now organisedBLookups by email get much faster; inserts get slightly slowerCThe table takes less space, because the index compresses itDDuplicate emails become impossibleCheck answer