Michael Brusser <[EMAIL PROTECTED]> writes:
> So 'rows' values are incorrect.
You sound like you are expecting them to be exact. They're just
estimates. They're all plenty close enough for planning purposes,
except maybe the one for 'KnowledgeBase' is a little further off
than I would have expec
On Wed, 21 Jan 2004, Michael Brusser wrote:
> So 'rows' values are incorrect.
You can increase the statistics-gathering for that column with ALTER TABLE
and probably get better estimates.
> Also looking at queries with 'KnowledgeBase'
> and 'OtherParam' - does seq. scan make sense?
>
> I mean
> What's the actual distribution of values in these columns?
> Are you searching for values that are particularly common
> or uncommon?
This column always has a predefined set of values.
Usually the app. would search for one of the
existing values.
---
Total records:
