How do you optimize database performance for large datasets?

1

What techniques or indexing strategies help improve query speeds for massive databases?