Home » SQL & PL/SQL » SQL & PL/SQL » ANALYZE INDEX
ANALYZE INDEX [message #272973] Mon, 08 October 2007 07:58 Go to next message
amit85
Messages: 11
Registered: May 2007
Location: DELHI
Junior Member


I want some help in understanding difference between following two commands & which should be done on what situation ?

ANALYZE INDEX IDXNAME COMPUTE STATISTICS;
V/s.
ANALYZE INDEX IDXNAME VALIDATE STRUCTURE;

Pl. help in understanding these two..

Thanks

Amit
Re: ANALYZE INDEX [message #272976 is a reply to message #272973] Mon, 08 October 2007 08:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64126
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ANALYZE

Read this page and tell us what you don't understand in it.

By the way, don't use ANALYZE to gather statistics but DBMS_STATS.

Regards
Michel
Re: ANALYZE INDEX [message #272977 is a reply to message #272973] Mon, 08 October 2007 08:09 Go to previous messageGo to next message
amit85
Messages: 11
Registered: May 2007
Location: DELHI
Junior Member

Thanks for your reply.
There is no page opening when clickon on ANALYZE.
I am using oracle Version 8.1.5.

Regards

Amit
Re: ANALYZE INDEX [message #272981 is a reply to message #272977] Mon, 08 October 2007 08:13 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Amit,

Michael is referring to the following link.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4005.htm#i2086320

Regards

Raj

P.S : Out of curiosity can i ask you why you are still using Oracle 8 ?
Re: ANALYZE INDEX [message #272982 is a reply to message #272977] Mon, 08 October 2007 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64126
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry I use the wrong window.
The link I wanted to post is ANALYZE

The basics don't change with 8i version. I don't remember if dbms_stats was there in this version, I don't think so.

ALWAYS POST YOUR VERSION NUMBER IN THE POST (with 4 decimals).

Regards
Michel

[Updated on: Mon, 08 October 2007 08:16]

Report message to a moderator

Re: ANALYZE INDEX [message #272984 is a reply to message #272973] Mon, 08 October 2007 08:19 Go to previous message
amit85
Messages: 11
Registered: May 2007
Location: DELHI
Junior Member

Thanks Raj its open now.

Our company is not upgrading Oracle's new version hence still working on that version.

Regards,

Amit
Previous Topic: how to use ORDER BY clause in VARCHAR2 datatype column?
Next Topic: user password
Goto Forum:
  


Current Time: Wed Dec 07 06:44:19 CST 2016

Total time taken to generate the page: 0.17839 seconds