Oracle安装配置和使用浅析.ppt

Oracle Database 10g: 2 Day DBA for Windows 1-* Managing Indexes Indexes are optional structures that are associated with tables. They can be created to increase the performance of data retrieval. An Oracle index provides a direct access path to table data. Indexes can be created on one or more columns of a table. After an index is created, it is automatically maintained and used by the Oracle server. When a table is updated, changes to the relevant indexes are automatically made with complete transparency to the user. You can click the Indexes link under the Schema heading of the Administrat