My grandfather started programming with the IBM 2300 magnetic drum. Then came tracks and cylinders, files, ISAM, SQL. Each step absorbs the previous one. Indexes will be automatic one day for sure. But for now the design of it is the responsibility of the programmer. Indexes usually take up more space than tables. I've seen systems with terabytes of indexes. Indexes are a drag. Quantum computers will finish them off.