Stephan Szabo <[EMAIL PROTECTED]> writes:
>> statistic ( n_distinct in particular) records for one of my columns,
>> greatly under calculated it saying:
>> 49726, but in reality 33409816.
>> is it any way how I can improve that?
> You might see if raising the statistics target with ALTER TABLE ALT
On Tue, 8 Jul 2003, Maksim Likharev wrote:
> Hi,
> I just found very interesting situation,
> statistic ( n_distinct in particular) records for one of my columns,
> greatly under calculated it saying:
>
> 49726, but in reality 33409816.
>
> So planer never choose index but rather using table scan
Hi,
I just found very interesting situation,
statistic ( n_distinct in particular) records for one of my columns,
greatly under calculated it saying:
49726, but in reality 33409816.
So planer never choose index but rather using table scan, and query
never returns,
is it any way how I can improve
