Use Proper IndexingAvoid SELECT * and Retrieve Only Required ColumnsUse Proper Data TypesAvoid Nested Subqueries and Use Joins