On Dec 18, 2007 10:54 AM, Weber, Geoffrey M.
<[EMAIL PROTECTED]> wrote:
> Tom,
>
> Yes, the distribution must be what's doing it.  I guess I knew that 
> subconciously, but was looking for something like hints to force the planner 
> to do what I wanted.  Instead it looks like I'll have to do a bit of tweaking 
> with my indexes.  Probably a partial index on the 'not_displayed_id' column.  
> It'll be very small and shouldn't cause much overhead.  I was trying to keep 
> my index count down, and have had a dual-column index on (replaced_by_id, 
> not_displayed_id) to this point.

Fix not with a hammer that which you can fix with a screwdriver.  Fix
not with a screwdriver that which you can fix with a knob

Have you tried increasing the stats target of the guilty column and
reanalyzing to see if that helps?

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to