Mu Sigma Interview Question

Can you explain how you would optimize a SQL query that retrieves data from a large table, ensuring efficient performance, and what specific indexing strategy would you use?