On Thu, 5 Aug 1999, Roberto Moreda wrote:
Have you vacuumed? Can you post your actual explain?
BTW, I would strongly encourage you to use boolean for this. I've
seen tables that used CHAR for such things and code that had to check for
one of the following values:
yYtT1 or nNfF
I have a speed problem with a query that involves 3 tables.
I focused the problem in a scan in a big table (7 rows) using a indexed
field. The field is a "flag" field which values only can be 'Y' or 'N'.
In the query I look for the values 'N' (average value = 10 rows over the
7). Postgres
