I'll get back to you on this Monday - I'm heading home for the week now.
However I was unable to adjust the statistics target using that command:
alter table opportunity.census_user set statistics 500;
ERROR: syntax error at or near "statistics"
LINE 1: alter table opportunity.census_user set statistics 500;
^
On Fri, Feb 1, 2013 at 4:55 PM, Виктор Егоров <[email protected]> wrote:
> 2013/2/1 Casey Allen Shobe <[email protected]>:
> > Rowcounts are shown in the earlier paste link, but apparently I forgot to
> > include the census table - hewitt_1_0_factors_precalc_new has 4,135,890
> > rows, and census_user has 1846439 rows.
> >
> > Statistics target is the default at 100.
>
> I would try the following:
> ALTER TABLE hewitt_1_0_factors_precalc_new SET STATISTICS 1000;
> ALTER TABLE census_user SET STATISTICS 500;
> ALTER TABLE census_output SET STATISTICS 500;
> and analyzed them after. I hope I guessed ‘census_output’ name correctly.
>
> And could you kindly share the plan after:
> SET enable_nestloop TO off;
>
>
> --
> Victor Y. Yegorov
>
--
Casey Allen Shobe
[email protected]
