← Back to questions
Postgres query is slow with LIKE search on large table
0
I have a users table with 2 million rows and this query is taking over 10 seconds:
SELECT * FROM users WHERE email LIKE "%@example.com"I have an index on the email column but it is not being used. How can I make this search faster?
Asked by @lTVzGIA0E5TJPPnBzEue
0 Answers
No answers yet. Be the first to answer below.