SQL joins in an interview: how deep do you go?

Inner vs left is the easy part. Interviewers sometimes push on indexes and query plans. Is it better to name the tradeoff and move on, or go deep when asked? Looking for what held up in real rounds.