Pergunta de entrevista da empresa Everly Health

How would you resolve a SQL query performance for queries used in complex JOINs? For behavioral the director asked (which is a common question), tell me a time when you had a negative feedback and how did you handle the situation.