Re: Wierd Table -- Aaargh!

> Thanks to everyone who responded. The overall consensus was that I > shouldcheck how often I am updatiing statistics. How often should it be > run?Daily? Hourly? Whenever some profound change has happened to the shape of the data - a massive delete or load, or a large number of data entry transactions for example. I find that having a cron job kick in each night is a good bet for most people. If your data is changing too rapidly for that then you could always run UPDATE STATISTICS FOR TABLE weird_table more often, to save it having to do the entire d/b. akent@cix.compulink.co.uk (Andy Kent) -------------------------------------