Re: Use my (date) index, darn it!

In the last exciting episode, siracusa@mindspring.com (John Siracusa) wrote:
> What column(s) should I increase?  Do I have to do anything after increasing
> the statistics, or do I just wait for the stats collector to do its thing?

You have to ANALYZE the table again, to force in new statistics.

And if the index in question is on _just_ the date column, then it is
probably only that date column where the "SET STATISTICS" needs to be
increased.
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://www.ntlug.org/~cbbrowne/sap.html
Faith  is the  quality that  enables you  to eat  blackberry jam  on a
picnic without looking to see whether the seeds move. -- DeMara Cabrera