Hi David, Your "table fetch continued row" count has certainly plummeted so something's changed there. When you say dba_tables shows nothing, you don't by any chance use dbms_stats to analyze as chain_cnt is only calculated with the "old" analyze command (else you just get a 0). In which case, yes, your pctfree is buggered. Just a thought. Cheers Richard ----- Original Message ----- From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, September 01, 2004 9:21 PM Subject: Why a rebuild speeds up my queries. Hi, I have a process that overtime slowly gets slower and slower (execution plans are the same) A rebuild of the table / index fixes this and makes it go quick again. I know that we shouldn't need to rebuild things, so I need to know what is wrong in my setup which is causing this. The setup is this: oracle 9.2.0.4 on Solaris Running queries against hashed partitioned table which never get deleted them, they only get inserted into and then updated a fair amount. We think it is due to row migration / chained rows but chain count from dba_tables showed nothing after an analyze. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------