What is Index?

Ads
 

What is Index?

What is Index?

View Answers

November 15, 2010 at 1:15 PM

Hi,

An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes, they are just used to speed up queries. Effective indexes are one of the best ways to improve performance in a database application.

An Index can be created on a single column or a combination of columns in a database table. A table index is a database structure that arranges the values of one or more columns in a database table in specific order. The table index has pointers to the values stored in specified column or combination of columns of the table. These pointers are ordered depending on the sort order specified in the index.

Thanks.

Ads









Related Tutorials/Questions & Answers:
what is bit
What is procedure
Advertisements
what is hibernate.archive.autodetection
What is JDBC?
What is FBT
What is ActionServlet?
What is Trigger?
What is VLR ?
What's PHP ?
What is an interface?
What is DML?
What is Index?
What is SQLLoader?
What is a "constraint"?
what is Savepoint ?
What is this keyword?
what is collections?
what are indices?
What is Hibernate
What is a transaction and what are ACID properties?
What is an Abstract Class and what is it's purpose?
What is Externalizable?
What is the % operator?
What is casting?
What is DataAccessException?
What is IOC ?
What is SQLExceptionTranslator?
What are Struts?
What is WAP?
What is SPOOL?
What is a tuple?

Ads