Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query running much slower after about 100000 rows inserted in the source table

Re: Query running much slower after about 100000 rows inserted in the source table

From: osy45 <member18536_at_dbforums.com>
Date: Sun, 23 Feb 2003 11:23:23 +0000
Message-ID: <2564503.1045999403@dbforums.com> 






Did you run analyze for the table and the referenced indexes?



analyze table <bla> compute statistics;


analyze index <idx_bla> compute statistics;



if the # of rows is very large you can estimate instead of compute
statistics



osy45


--
Posted via http://dbforums.com


Received on Sun Feb 23 2003 - 05:23:23 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US