Sent from my iPad
body{FONT-SIZE:12pt; FONT-FAMILY:宋体,serif;}
Thanks for your reply.
So correlation is not related to the calculation of selectivity right? If I force PostgreSQL not to optimize the join order (by setting join_collapse_limit and from_collapse_limit to 1) , is there any other factor that may affect the structure of execution plan regardless of the data access method.
2014-01-10
ygnhzeus
发送时间：2014-01-10 22:00
主题：Re: [GENERAL] How to specify/mock the statistic data of tables in PostgreSQL
AFAIK, correlation is involved in calculation of the costs that are used for deciding the type of access.If the correlation is low, index scan can lead to quite some random reads, hence leading to higher costs.
Regards,
Atri