SQL Arena
#1010

Name Prefix Search

CRM suggestions search for users whose name starts with A. Add an index on name so prefix search runs faster.

Speed this query up with an index
SELECT * FROM users WHERE name LIKE 'A%'

Samo CREATE/ALTER/DROP — zaključni SELECT ni potreben.

Prijavite se za oddajo

Rezultat vaše poizvedbe se bo prikazal tukaj