How do you optimize database performance for large datasets?

[rachitk]

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