Difficulty: Intermediate
Why is 'LIKE %keyword%' slow?
Leading wildcards prevent the database from using standard B-Tree indexes, forcing a full table scan. Full-Text Search (FTS) indexes are built specifically for these queries.
Search, Performance
JavaScript is required for the interactive version of this page, including the code playground and progress tracking. Browse all InternHack tutorials.