On Fri, Feb 1, 2013 at 4:12 PM, Виктор Егоров <vyegorov@xxxxxxxxx> wrote:
Statistics target is the default at 100.
--
Casey Allen Shobe
casey@xxxxxxxxxx
Estimated rows for ‘hewitt_1_0_factors_precalc_new’ are 1000x less then actual.
And for ‘census_user’ estimation is 100x less, then actual.
How many rows are in those tables and what is your statistics target?
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.
Casey Allen Shobe
casey@xxxxxxxxxx
