In the last exciting episode, [EMAIL PROTECTED] (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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly