Re: How to execute Analyze Command

A copy of this was sent to "michael.kurz" <m.kurz_at_okay.net> (if that email address didn't require changing) On Mon, 24 May 1999 15:07:36 +0200, you wrote:

>Hello
>
>I read that I can Speed up my Oracle DB
>with the ANAYZE Command.
>
>I tried to Execute that Command
>
>ANALYZE Tablename
>
>but I only get an Error Message
>
>ORA-01490: ungültiger ANALYZE-Befehl
>
>
>What do I have to do to Execute the Command ?
>
>Do I have to Install something ?
>

no, but you do have to read the documentation. The error message is telling you "invalid analyze command". oerr ora 1490 further shows "Incorrect syntax specified". Analyze has lots and lots of options to it -- you haven't given the database a valid analyze command.

analyze can speed up your database, it can slow it down. Your mileage may vary. please -- read about it, understand what it is really doing, test it on a test database. If you blindly just start analyzing some tables in your database, without understanding the implications, no good will come of it.

>Thanx
>Micha
>

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon May 24 1999 - 08:31:54 CDT