Re: how to force an index range scan?

From: <gdas_at_my-deja.com>
Date: Fri, 22 Sep 2000 20:11:19 GMT
Message-ID: <8qgecl$nrt$1@nnrp1.deja.com>

Sorry for so many posts here. But I seem to have found the problem. Don't quite understand it, but it will do for now.

I was analyzing the f_misc table sampling 20 percent and creating a 20 bucket histogram on all indexed columns. When I removed the histogram, I got my index range scan. I tried it with different predicate values for account_id and they all come back fast. Very strange. I knew histograms don't always help, I guess they can in fact hurt you sometimes as well.

Thanks for your time.
Gavin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 22 2000 - 15:11:19 CDT