Hi Shamim,
Explain Plan will give the oracle optimizer execution plan of the query,
Analyze table will gather the statistics that the CBO will use to decide
the execution plan.
Thanks and Regards,
Sriram Prabhu
-----Original Message-----
From: shamim akhtar
[mailto:oracledba-ezmlmshield-x5500908.[Email address protected]
Sent: Monday, March 31, 2008 11:58 AM
To: LazyDBA Discussion
Subject: difference between Explain Plan and Analyze Table?
Hi All
Please tell me.
The Difference between Explain Plan and Analyze Table?
Thanks
Shamim Akhtar
DISCLAIMER:
The contents of this e-mail (and any attachments) are confidential, may
be privileged and may contain copyright material of Company or third
parties. You may only reproduce or distribute the material if you are
expressly authorized by us to do so.
If you are not the intended recipient, any use, disclosure or copying of
this e-mail (and any attachments) is unauthorized. If you have received
this e-mail in error, please notify the sender via e-mail; delete it and
any copies of it from your system.
Although this message and its attachments have been scanned for viruses
and no viruses were detected, no responsibility whatsoever is accepted
by the Company for any loss or damage arising in any way from receipt or
use thereof.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
Oracle LazyDBA home page