From: Mark D Powell Subject: Re: Database Performance Date: 2000/07/07 Message-ID: <0d84a9bc.7b031137@usw-ex0103-024.remarq.com>#1/1 References: <39570A25.33DB2FBC@hotmail.com> <8j7ajb$1vf$1@nnrp1.deja.com> <3965FCFB.5A6B149F@euclidsys.com> Bytes: 677 X-Originating-Host: 199.228.142.8 X-Complaints-To: wrenabuse@remarq.com X-Trace: WReNphoon4 963001801 10.0.2.24 (Fri, 07 Jul 2000 13:30:01 PDT) Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here NNTP-Posting-Date: Fri, 07 Jul 2000 13:30:01 PDT Newsgroups: comp.databases.oracle.server X-Wren-Trace: eAsuBgceWRNYRh4RBQUaDQ4dFwIuCk8OQAQLBUJOSxJKXxlSSxpKV0lS 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