Re: oninit -s and cpu utilization

rom: michele.orcutt@windmere.com > >Unfortuately or fortunately the index bug does not seem to be the problem. > >Please find attached the results of onstat -a. And how. :-) Nothing major there that I could see, I therefore reckon it might be an index or SQL problem. >My favorite clown, slow meaning when a request (ie a select) Ssh! Don't tell everybody! :) >is made of the database for information,too often it takes long time to >return >the data,and the processes are not being locked out of the tables by other >processes. Can you try SET EXPLAIN ON and then run one of the offending queries? >How often should indexes on highly utilized tables be dropped and >recreated? Never? Well, not often. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com