Shiar <[EMAIL PROTECTED]> writes:
>> EXPLAIN ANALYZE SELECT id FROM userinfo WHERE icq <> '0';
> Seq Scan on userinfo (cost=0.00..47355.90 rows=849244 width=4) (actual
> time=0.563..1222.963 rows=48797 loops=1)
>Filter: (icq <> 0::bigint)
> Total runtime: 1258.703 ms
The rows estimate is w
We've got a table containing userdata, such as a bigint column 'icq'. To
easily check whether a user has an icq number entered, we made the following
index:
userinfo_icq_ne0_id_key btree (id) WHERE (icq <> 0::bigint),
However, it doesn't seem to be used:
> EXPLAIN ANALYZE SELECT id FROM
