Index - Data Structure for Query Performance in Oracle

Q

What Is an Index in Oracle?

✍: FYIcenter.com

A

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.

 

Run SQL Statement through Web UI in Oracle

Managing Oracle Table Indexes

Managing Oracle Table Indexes

⇑⇑ Oracle Database Tutorials

2019-05-10, 1384🔥, 0💬