Query optimizer & prepared statements

Поиск
Список
Период
Сортировка
От Jack Orenstein
Тема Query optimizer & prepared statements
Дата
Msg-id 4A413C23.7090704@hds.com
обсуждение исходный текст
Ответы Re: Query optimizer & prepared statements
Re: Query optimizer & prepared statements
Список pgsql-general
If x is an integer column with an index, then

     select ...
     from T
     where x > 1

and

     select ...
     from T
     where x > 1000000000

could be optimized differently. So how is optimization done for a prepared
statement containing a variable, e.g.

     select ...
     from T
     where x > $1

Jack Orenstein


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