ANALYZE TABLE STATEMENT [message #677963] |
Sat, 26 October 2019 01:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Bilal Khan
Messages: 128 Registered: April 2010 Location: Pakistan
|
Senior Member |
|
|
HI EXPERTS.
i want to analyze table and want to know the number of Block in a table using Analyze table statement,
i use this query in sql plus:
ANALYZE TABLE Lineitem COMPUTE STATISTICS FOR TABLE;
Table analyzed.
as it display message that table analyzed but it did not display any thing, how can i display the number of block using analyze table statements,
thanks and regards.
|
|
|
Re: ANALYZE TABLE STATEMENT [message #677965 is a reply to message #677963] |
Sat, 26 October 2019 01:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You should never use ANALYZE TABLE...COMPUTE STATISTICS, not since (if I remember correctly) release 8i. It will destroy the histograms generated by dbms_stats.
|
|
|
|
|
|
|
|
|
|
|
|
|