Index and Types of Index in Oracle and it’s Advantages. Hello Everyone, Today I will discuss about Index and types of index in Oracle and its advantages. I suggest you to please follow my previous blogs related to SQL topics for better understanding. Let’s start why index is used in SQL database and the types of index and benefits of using index for query performance. Index is an object which is associated with tables or table cluster that can used to speed data access and reducing disk I/O. By creating an index, you can retrieve related set of rows from table instead of all Rows. In database technologies (Oracle, SQL Server, Sybase, DB2, MySQL, etc.), the objects we create to access the data for fast retrieval is known as Index: The usage of Index is very common especially in the performance tuning of database. Index is one of the most important objects that are used for performance tuning of databases. When any data is queried from a t...
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.