Write a query to fetch duplicate records from a user table and explain how you would optimize this query using indexing.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.