Xref: alice comp.databases.oracle.server:83012 Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!news-MUC.ecrc.net!bignews.mediaways.net!diablo.theplanet.net!newsfeed.esat.net!news.esat.net!not-for-mail From: "Keith Jamieson" Newsgroups: comp.databases.oracle.server Subject: Performance Questions Re-Indexes Date: Wed, 2 Feb 2000 09:53:42 -0000 Organization: Esat Net Lines: 19 Message-ID: <878uue$7lr$1@kermit.esat.net> X-Trace: kermit.esat.net 949485326 7867 193.120.136.69 (2 Feb 2000 09:55:26 GMT) X-Complaints-To: abuse@esat.net NNTP-Posting-Date: 2 Feb 2000 09:55:26 GMT X-Newsreader: Microsoft Outlook Express 4.72.3612.1700 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700 I have a rapidly growing table at a customer site(Currently contains 1.2 million rows). Some indexes were created for this table. When they were put on initially the query times returned were acceptable, but as the table has grown the query times have got worse. I am also aware of some coding issues which need to be resolved, but initially I would just like the benefits of this groups experience. Q1) Am I correct in assuming that the Indexes should be recreated on a regular basis? Q2) If we switched to the cost based optimiser, could I assume that as long as the statistics were regenerated on a regular basis, then the performance would be better than the rule based optimiser.