easy5 pts · first answer countsindexing

When a B-tree index helps

Which query is a B-tree index on users(email) most likely to speed up?

A.SELECT COUNT(*) FROM usersB.SELECT * FROM users WHERE email = 'asha@example.com'C.SELECT * FROM users WHERE email LIKE '%@gmail.com'D.SELECT * FROM users ORDER BY created_at

Discussion 0

Join free to post in the discussion.

When a B-tree index helps

Discussion 0

Related questions