SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectDebugging Questionsm1 indexing strategy

Debug Leading Wildcard Search

Fix this high-latency search query: SELECT user_id, full_name FROM users WHERE full_name LIKE '%john%';

Schema Context

users(user_id, full_name, full_name_search)