В Срд, 11/05/2005 в 22:59 +0200, Guillaume Smet пишет:
> Anyway, I tried to work on the statistics as you told me and here are
> the results:
> ccm_perf=# ALTER TABLE acs_objects ALTER COLUMN object_id SET STATISTICS 30;
> ALTER TABLE
> ccm_perf=# ANALYZE acs_objects;
> ANALYZE
>
> ccm_perf=# \i query_section.sql
> ... correct plan ...
> Total runtime: 0.555 ms
Given Tom's analysis, how can increasing the stats target change which
plan is chosen?
--
Markus Bertheau <twanger@bluetwanger.de>
