Re: Index only scans for expressional indices when querying for the expression

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Index only scans for expressional indices when querying for the expression
Дата
Msg-id CAKFQuwZTD0NydFg8Ra4kUuU2WDxY53FCx9Zh6_OwVjdCLThp8w@mail.gmail.com
обсуждение исходный текст
Ответ на Index only scans for expressional indices when querying for the expression  (Danny Shemesh <dany74q@gmail.com>)
Ответы Re: Index only scans for expressional indices when querying for the expression
Список pgsql-general
Дерево обсуждения
On Thursday, August 4, 2022, Danny Shemesh <dany74q@gmail.com> wrote:
I believe the expressional index in itself could've been considered as covering, when querying for the expression explicitly.

This belief is wrong.  When storing f(x) there is no way to recover the value of x.

David J.
 

В списке pgsql-general по дате отправления: