On Mon, 21 Oct 2002, Williams, Travis L, NPONS wrote:
> I did do a vacuum.. but I don't know what analyze does..
Analyze will update the statistics on the table that are used
for planning purposes. If for example explain shows that it's doing
a sequential scan, it may not for example realize that the index is
useful in limiting the number of rows sufficiently to beat the
sequential scan.