By account number (exact match, primary key index) - By customer name (last name exact, first name LIKE, name index) - By SSN hash (exact match, SSN hash index) - By date range + account type (range scan, composite index)