Oracle Database Developer Question:

Download Job Interview Questions and Answers PDF

Explain Table Index in Oracle?

Oracle Database Developer Interview Question
Oracle Database Developer Interview Question

Answer:

Index is an optional structure associated with a table that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle Database index provides a faster access path to table data. You can use indexes without rewriting any queries. Your results are the same, but you see them more quickly.

Download Oracle Database Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Database Table in Oracle?Explain Oracle Data File?