What is Analyze ?

From: Arif <arif_mohammed_at_i2.com>
Date: 8 Jun 2001 12:23:38 -0700
Message-ID: <3f2585f1.0106081123.28bc7f6@posting.google.com>

There is a popular SQL script called analyze.sql

What does this script do to the database ?
Is it advisable to execute this script on all databases, or are there only certain cases where it helps to execute this script ?
My intent is to get user_tables and user_tab_columns tables populated. I know if I run Analyze.sql these tables get populated. Is there any other quicker way to get these two tables populated because analyze.sql takes too long to execute.

Thanks
AM Received on Fri Jun 08 2001 - 14:23:38 CDT