prog - Search results

2001-10-18 09:40:33 | Re: index problem (CoL)

prog_id,prog_ftype,prog_fcasthour,prog_date from prog_dgy_xy,prog_data where

2001-10-17 14:00:34 | Re: index problem (Stephan Szabo)

prog_data) as well? It seems to be overestimating the number of joined rows, and I wonder

2001-10-17 08:34:01 | Re: index problem (CoL)

prog_data has ~8800 rowsn and index on prog_id: bash-2.04$ time echo "explain

2001-10-16 19:58:57 | Re: index problem (Stephan Szabo)

prog_data.prog_id should be unique. Hmm, does the explain change if you vacuum

2001-10-16 15:01:15 | index problem (Szabo Zoltan)

PROG_ID,PROG_FTYPE,PROG_FCASTHOUR,PROG_DATE from PROG_DATA, PROG_DGY_XY where