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%'

Ainult CREATE/ALTER/DROP — lõpus pole vaja SELECT-i.

Logi sisse, et esitada

Sinu päringu tulemus ilmub siia