Question
Postgres query is slow with LIKE search on large table
4993220e-2406-489f-89b1-dd847e7da617
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?