Home » RDBMS Server » Server Administration » Analyze table
Analyze table [message #56591] Thu, 10 April 2003 04:55 Go to next message
Manish tiwari
Messages: 6
Registered: April 2003
Junior Member
What does analyze table do ?

Does it flushes the sql from memory ?

Report message to a moderator

Re: Analyze table [message #56593 is a reply to message #56591] Thu, 10 April 2003 07:32 Go to previous messageGo to next message
Yan Seiler
Messages: 13
Registered: December 2001
Junior Member
It gives Oracle info about how it should get the data (use index, full scan) according to the number of lines in the table and the setup of the optimizer (cost based, rule based). Be carefull that old statistics could conduct oracle to a bad choice.

You can also detect any chained rows in your oracle blocks with this command.

AFAIK, it does not flush anything from the memory.

Hope this helps

Yan

Report message to a moderator

Re: Analyze table [message #56628 is a reply to message #56591] Sat, 12 April 2003 07:41 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hi,
Flushing ? no way..
its to get the estimates / value Oracle is maintaining for u r table.

sai

Report message to a moderator

Previous Topic: Cursors and COMMIT
Next Topic: http service error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:40:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.