Showing posts with label Locks. Show all posts
Showing posts with label Locks. Show all posts

Friday, January 12, 2024

SQL Indexes | Types of indexes | Creating an Index | Dropping an Index | OLAP | LOCKS | Basics of Oracle SQL | SQL

 

INDEXES

What is an Index?

  • An index is a schema object.
  • Is used by the Oracle server to speed up the retrieval of rows by using a pointer.
  • Can reduce disk I/O by using a rapid path access method to locate data quickly. 
  •  Is independent of the table it indexes. 
  •  Is used and maintained automatically by the Oracle server.

Note: When you drop a table, corresponding indexes are also dropped.