Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')
| От | Loles |
|---|---|
| Тема | Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') |
| Дата | |
| Msg-id | CA+FWGK480H3mRVsSy0xofYhvpx9W1Y_h6nGfoOh0tuE0ecJ45g@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')
Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') RE: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') |
| Список | pgsql-admin |
Hi!
A question about query optimization.
We have a simple query with several tables joined.
We have seen performance down when we use WHERE UPPER(name) LIKE UPPER('%Alice%') in the condition.
If we compare with WHERE UPPER(name) = UPPER('Alice') it runs very fast.
We have tried an index on the name field, an UPPER(name) expression index, a GIN index, etc. but nothing seems to work.
We need to optimize the condition WHERE UPPER(name) LIKE UPPER('%p_name%)
We have a simple query with several tables joined.
We have seen performance down when we use WHERE UPPER(name) LIKE UPPER('%Alice%') in the condition.
If we compare with WHERE UPPER(name) = UPPER('Alice') it runs very fast.
We have tried an index on the name field, an UPPER(name) expression index, a GIN index, etc. but nothing seems to work.
We need to optimize the condition WHERE UPPER(name) LIKE UPPER('%p_name%)
Any ideas?
Thanks!!
В списке pgsql-admin по дате отправления: