New ANALYZE TABLE/INDEX script added.....

From: David Sisk <davesisk_at_ipass.net>
Date: Mon, 1 Feb 1999 21:07:04 -0500
Message-ID: <OS7t2.765$24.2272@news.ipass.net>

Hi comrades:

I've added a new ANALYZE TABLE/INDEX script to the web-site below. This script reads the data dictionary, generates the necessary DDL commands, and spools them to a file, then runs the file that these commands were spooled to. The script and command file can be added to the O/S scheduler to make collection of optimizer statistics an automated function.

Even though the site is specific to Oracle on NT, the SQL script will actually work with Oracle on any platform (it just requires a different shell script to run it).

Enjoy!

Regards,

David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm Received on Mon Feb 01 1999 - 20:07:04 CST