| 1. | analyze materialized view | | |
| 2. | analyze index | | |
| 3. | Analyze table with primary key and foreign key | | |
| 4. | Demonstrate IN versus EXISTS performance | | |
| 5. | analyze table tableName compute statistics for table, for all indexes, for all indexed columns; | | |
| 6. | ANALYZE TABLE employee COMPUTE STATISTICS | | |
| 7. | analyze index validate structure | | |
| 8. | analyze table compute statistics | | |
| 9. | analyze table compute statistics for all indexes | | |
|
| 10. | analyze table compute statistics for a table with two indexes | | |
| 11. | create or replace outline and analyze table compute statistics | | |
| 12. | Analyze a table with/without index | | |
| 13. | Anayze all objects in the APPOWNER schema. | | |
| 14. | Analyze index on varchar2 value and date type value | | |
| 15. | analyze and autotrace full outer join and union | | |
| 16. | analyze and autotrace single column key and multi-column key | | |
| 17. | analyze and autotrace table with primary key | | |
| 18. | analyze index t_idx validate structure | | |
| 19. | analyze table TABLENAME compute statistics; | | |
| 20. | analyze table after creating index | | |
| 21. | analyze table estimate statistics | | |
| 22. | analyze table students compute statistics | | |
| 23. | analyze table t compute statistics for table for columns id; | | |
| 24. | analyze table t compute statistics for table, for all indexes, for all indexed columns | | |