Re: Database Performance

From: Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid>
Date: 2000/07/07
Message-ID: <0d84a9bc.7b031137@usw-ex0103-024.remarq.com>#1/1

Ask your DBA if the table has been analyzed recently using a full compute or large sample size. After analyzing if performance does not improve then you might want to check for chained rows. The existance of more than a few percent worth of chained rows is not good and can have a very nasty effect on performance. If there are no chained rows then you should look at the explain plan, post it, and the index information then someone will probably be able to point you in the right direction.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Fri Jul 07 2000 - 00:00:00 CDT