What Is a Table Index

Categories:

.NET (357)

C (330)

C++ (183)

CSS (84)

DBA (2)

HTML (4)

Java (574)

JavaScript (106)

JSP (66)

Oracle (114)

Perl (46)

Perl (1)

PHP (1)

RSS (51)

Software QA (13)

XHTML (173)

Other Resources:

Software QA Resources

Developer Resources

Windows Tutorials

File Extensions

Security Certificates

Regular Expression

Link Directories

Interview Q & A

Biotech Resources

Cell Phone Resources

Travel Resources

Frequently Asked Questions

FYIcenter Forum

Home > Oracle > Index

What Is a Table Index

Q

What Is a Table Index? - Oracle DBA FAQ - Managing Oracle Table Indexes

✍: 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.

2007-05-02, 4747👍, 0💬

Popular Posts:

How can we implement...

How can we implement singleton pattern in .NET? Singleton pattern mainly focuses on having one and o...

Can you explain diff...

Can you explain different software development life cycles -part II? Water Fall Model This is the ol...

What is a measure in...

What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To...

How do you locate th...

How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...

include Directive vs...

What is the difference between include directive & jsp:include action? Difference between includ...