Re: Wierd Table -- Aaargh!

Pete Stiglich (pete@afc.org) wrote: > : It is using a unique index on 3 columns for the query. I've tried dropping > :& recreating the index, clusturing it, bchecking the table & nothing works. > : The only thing that gets it back to normal is unloading the table, dropping > : it and recreating and reloading. > Thanks to everyone who responded. The overall consensus was that I should > check how often I am updatiing statistics. How often should it be run? > Daily? Hourly? No answer here. Try it and see. And do the entire database every now and then. The more Inserts, Deletes and Updates of the indexed columns you have, the more often you should Update Statistics. Also, if the size of the table decrease, you might want to compress the table. Danni