Oracle - What Is a Table Index in Oracle

What Is a Table Index in Oracle

Q

What Is a Table 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.

⇒Oracle Database Basic Concepts

⇒⇒Oracle Database Tutorials

2016-10-17, 402👍, 0💬

Popular Posts:

sys.sql_modules - Ge...

How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...

Oracle Database Tuto...

Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...

Unicode Character St...

How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

NULLIF() - Replacing...

How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...