Solution : https://service.sap.com/sap/support/notes/912620 (SAP Service marketplace login required)
Summary :
This SAP Note provides a comprehensive explanation on various aspects of indexes utilized within an Oracle database context, especially in connection with SAP applications. It covers the basic definition, purposes, structural details, and types of indexes like B*Tree and Bitmap. Details on index creation, usage for data access efficiency, and the temporary deactivation of indexes are also discussed. Furthermore, it emphasizes the considerations for index design, index fragmentation, and their impacts on database performance. It provides guidance on utilizing indexes to maximize query performance while cautioning about potential downsides like increased storage and performance degradation due to additional indexes.
Key words :
oracle documentation underoracle database concepts-> schema objects-> indexes, index organized tables index organized tables, statement alter index <index_name> monitoring usage, alter index <index_name> nomonitoring usage, processing-intensive table search unnecessary, execute alter index monitoring usage, system finds suitable data records, read additional relevant data records, oracle shared cursor cache, activate index usage monitoring
Related Notes :
| 1109743 | Use of Index Key Compression for Oracle Databases |
| 915242 | FAQ: Reverse key indexes |
| 832343 | FAQ: Clustering factor |
| 806554 | FAQ: I/O-intensive database operations |
| 771929 | FAQ: Index fragmentation |
| 766349 | FAQ: Oracle SQL optimization |
| 750631 | Approximations for cost calculation of the CBO |
| 641435 | FAQ: Oracle Index Organized Tables (IOTs) |
| 334224 | Important notes for creating indexes |
| 105047 | Support for Oracle functions in the SAP environment |