Oracle - Index - Data Structure for Query Performance in Oracle

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.

⇒Managing Oracle Table Indexes

⇒⇒Oracle Database Tutorials

2016-10-17, 360👍, 0💬

Popular Posts:

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

Passing Values to St...

How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...

OUTPUT - Defining Ou...

How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...

CHARINDEX() and SUBS...

How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...