SQL Quiz
10 questions · no time limit
0:00
PERFORMANCE AND OPTIMIZATION
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
Customers.customer_id is an integer primary key. A large imported Events table stores the corresponding value in a text column named customer_id_text, which has a B-tree index. A join converts Events.customer_id_text to an integer before comparing it with Customers.customer_id. The plan scans the large Events table because the conversion is applied to its indexed column.Which long-term change is most likely to make the join index-friendly and reliable?
YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end