Hello,
I would appreciate if someone explained me how exactly prepared parametrized
statements are planned, i.e. what kind of assumptions planner makes on param
values, selectivity, expected row count etc. that affect in particular
whether indexes will be used or not. For instance consider the
Vyacheslav Kalinin wrote:
Hello,
I would appreciate if someone explained me how exactly prepared
parametrized statements are planned
http://www.postgresql.org/docs/8.2/static/sql-prepare.html
Under the Notes it explains it can't use an index and has to basically
guess what it's going to do