Home » SQL & PL/SQL » SQL & PL/SQL » ANALYZE
ANALYZE [message #20784] Thu, 20 June 2002 02:19 Go to next message
Anand
Messages: 161
Registered: August 1999
Senior Member
ANALYZE TABLE t delete statistics
how it works?
any idea..or details?

Report message to a moderator

Re: ANALYZE [message #20787 is a reply to message #20784] Thu, 20 June 2002 06:14 Go to previous message
vipin
Messages: 40
Registered: May 2002
Member
Hi,

This is used to gather statitics for a table which is used by the cost based optimizer to determine an effective execution plan.

vipin

Report message to a moderator

Previous Topic: min and max functions.
Next Topic: SQL QUERY
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 16:38:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.