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, 1514🔥, 0💬