On 23 avr, 14:12, [EMAIL PROTECTED] (Gregory Stark) wrote:
> <[EMAIL PROTECTED]> writes:
> > This is the result of an EXPLAIN:
> >...
> > I suppose that the problem comes from the Bitmap Heap Scan which costs
> > a lot, but I can't be totally sure.
>
> > Any idea on where I should be investigating
Hello,
I have a big table (around 3 600 000 entries) which stores which user
has seen which subjects in a forum.
This query is executed every time a user connects to the forum:
SELECT flg_rid
FROM prj_frm_flg
WHERE flg_mid=3 AND NOT flg_fav AND NOT flg_notif AND NOT flg_post
ORDER BY flg_rid DESC
