Optimizer + bind variables

Поиск
Список
Период
Сортировка
От David Kerr
Тема Optimizer + bind variables
Дата
Msg-id 20091103174729.GA55736@mr-paradox.net
обсуждение исходный текст
Ответы Re: Optimizer + bind variables
Список pgsql-performance
Does/is it possible for the PG optimizer come up with differnet plans when
you're using bind variables vs when you send static values?

like  if my query was

select * from users (add a bunch of complex joins) where username = 'dave'
vs
select * from users (add a bunch of complex joins) where username = '?'

In oracle they are frequently different.

if it's possible for the plan to be different how can i generate an
xplan for the bind version?

Thanks!

Dave

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