I hall
I have a query in this form:
empdb=# explain analyze select * from v_past_connections where id_user = 26195 and
login_time '2004-07-21';
QUERY PLAN
On Fri, 23 Jul 2004, Gaetano Mendola wrote:
empdb=# explain analyze select * from v_past_connections where login_time
'2004-07-21';
QUERY PLAN
Dennis Bjorklund [EMAIL PROTECTED] writes:
In this plan it estimates to get 481 but it got 22477. So the estimation
was very wrong. You can increase the statistics tarhet on the login_time
and it will probably be better (after the next analyze).
Given the nature of the data (login times),