-
If I run ANALYZE TABLE table_name COMPUTE STATISTICS;
am I analyzing indexes also?...how about indexed columns?
or do I need to run following command along with the first one?
ANALYZE TABLE table_name COMPUTE STATISTICS FOR ALL INDEXES
ANALYZE TABLE table_name COMPUTE STATISTICS FOR ALL INDEXED COLUMNS
If I want to have complete analyze on tables, indexes, and etc.... which command should I use?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|