Re: Optimizer taking too long to determine query path

>Thanks for the response!!!!! > >A few people e-mailed me suggesting Update Statistics be run. We do >run it on a weekly basis. Well, you might *think* that's the case, but you could be in for a surprise. We had a production system that wouldn't purge, and US was being run weekly. I persisted and we ran a midweek MEDIUM DISTIRBUTIONS ONLY and performance improved dramatically. >Let me tell you about this... there is a particular example I have of >restoring a similar database on the same server (using dbimport). I >cut out the update statistics from the import script. Then, of course >many queries were taking longer.... but some of them (the really long >10,000 second ones) began running in under a minute. I ran Update >Statistics and the really long query times came back for those queries. > >I think I'm looking for a way to figure out how I can set up the >indexes (maybe just delete many of them) so that the optimizer doesn't >spend so much time analyzing the appropriate index path.... But I will >take a closer look at our weekly Update Statistics Scripts. I think that's a *very* good idea. And remember, more than once a week is not necessarily a bad thing. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com