Hi John,
> Try: explain SELECT mailbox_idnr FROM mailboxes WHERE
> owner_idnr=2::bigint;
No difference:
dbmail=> explain SELECT mailbox_idnr FROM mailboxes WHERE
owner_idnr=2::bigint;
QUERY PLAN
---------------------------------------------------------
Seq Scan on mailboxes (cost=0.00..1.06 rows=3 width=8)
Filter: (owner_idnr = 2::bigint)
> dbmail=> explain SELECT mailbox_idnr FROM mailboxes WHERE owner_idnr=2;
> QUERY PLAN
> ---------------------------------------------------------
> Seq Scan on mailboxes (cost=0.00..1.06 rows=3 width=8)
> Filter: (owner_idnr = 2)
> (2 rows)
>
> The table has an index on owner_idnr.
--
MfG Thomas Mueller - http://www.tmueller.com for pgp key (95702B3B)
