Re: using sequential scan instead of index for join with a union

ble, notice.id or > notice.mbct_id datatypes does not match with other tables. > > regards, Sergei > -- Kent Tong IT author and consultant, child education coach

using sequential scan instead of index for join with a union

ond: (mbct_id = y.id) -> Seq Scan on speech s (cost=0.00..26.82 rows=1 width=48) (actual time=0.139..0.139 rows=0 loops=130) Filter: (y.id = mbct_id) Rows Removed by Filter: 226 Planning Time: 0.639 ms Execution Time: 21.604 m The size of the three tables are 27430, 226 and 1766 respectively. Many thanks for any help! -- Kent Tong IT author and consultant, child education coach