RE: Which index is used in the index scan.

Hi, Andreas Thank you your reply. This problem was solved. I revalidated your advice, source code and the statistics. As a result, the cost was changing due to the difference in the index height. Regards, SAKAI Teppei > On 17 October 2018 07:39:48 CEST, "Sakai, Teppei" &g

Which index is used in the index scan.

t each index were the same. We did not rebuild or update indexes. What are the reasons why the index has been changed besides the following factors? - cost values - Index creation order PostgreSQL version : 9.5.2 Regards, SAKAI Teppei