Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!usc!snorkelwacker!mit-eddie!uw-beaver!zephyr.ens.tek.com!tektronix!sequent!larrys
From: larrys@sequent.UUCP (Larry Scheurich)
Newsgroups: comp.databases
Subject: Oracle optimizer
Keywords: SQL, ORACLE
Message-ID: <27180@sequent.UUCP>
Date: 4 Jan 90 21:18:14 GMT
Reply-To: larrys@sequent.UUCP ()
Organization: Sequent Computer Systems, Inc
Lines: 11


Does anyone out there know of an oracle utility that gives statistics about
data in a table.  In Ingres, there is the optimizedb command.  It provides
nice statistics that the query optimizer uses.  I was wondering if anyone 
knows of or has written a utility like this for Oracle.  I'm not looking
to use it as a query optimizer, but we are trying to find a way to 
capture statistics on our data to double check indexes and data integrity.

Thanks,
Larry Scheurich			uunet!sequent!larrys
Sequent Computer Systems	(503)-526-4240