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)
On Fri, 23 Jul 2004, Gaetano Mendola wrote:
> empdb=# explain analyze select * from v_past_connections where login_time >
> '2004-07-21';
>QUERY PLAN
> -
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
--