statistics for COB

From: Colt <olithomas_at_free.fr>
Date: Wed, 17 Dec 2003 23:02:29 +0100
Message-ID: <3fe0cf39$0$28701$626a54ce@news.free.fr>

Hi,

I have an Oracle database with one million records in it. It is actually an Oracle DB with OID running above for LDAP. I order to optimize the response time of my database I was advised to run the following SQL command on each table for Optimizer to be efficient and have a significant gain in my response times : analyze table my_table estimate statistics sample 30 percent;

I have 2 questions :
- What is the usual gain when running such script ?

When I run it, can I continue reading, creating or deleting records or should I stop everything ?

Thanks for your advises,
C. Received on Wed Dec 17 2003 - 16:02:29 CST