- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
for_clause
The following is the syntax for the for_clause in the ANALYZE TABLE statement:
{
FOR TABLE |
FOR ALL [INDEXED] COLUMNS [SIZE integer] |
FOR COLUMNS column_name [SIZE integer] |
FOR ALL [LOCAL] INDEXES
}- FOR TABLE
Specifies that only the table is to be analyzed.
- FOR ALL COLUMNS
Specifies that, instead of the table, all columns are to be analyzed; if you specify INDEXED, all indexed columns will be analyzed. SIZE specifies the number of buckets to be generated when columns are being analyzed.
- FOR COLUMNS
Provides a list of columns to be analyzed.
- FOR ALL INDEXES
Specifies that, instead of the table, all indexes are to be analyzed. This is equivalent to executing an ANALYZE INDEX command for all indexes. If you specify LOCAL, all local indexes will be analyzed.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.