DB2 - What is the roll of INDEX in a query?

GeekInterview.com > Interview Questions > Mainframe > DB2

Go To First | Previous Question | Next Question

DB2 | Question 110 of 195

What is the roll of INDEX in a query?

Total Answers and Comments: 4

Last Update: February 18, 2006 Asked by: sachin

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 29, 2005 16:36:46

KALIA

RE: what is the roll of INDEX in a query?

INDEX IS THE PREDEFIND .THROUGH WHICH WE CAN ACCESS TABLE ELEMENTS

Is this answer useful? Yes | No

December 02, 2005 02:35:37

Syam

RE: what is the roll of INDEX in a query?

In a query if there is an index it will make the search faster ....usually indexes are recommended in the WHERE clause

Is this answer useful? Yes | No

February 03, 2006 08:43:09

pradipta

RE: what is the roll of INDEX in a query?

INDEX is generally used to make query access faster.It also takes less time for execution b'use it will not go for searching all the data's in the table.It will search only by using that INDEX.INSEX is created on the column of a table.Then a condition has also given in WHERE clause which will make it also more faster.

Is this answer useful? Yes | No

February 18, 2006 05:58:15

pjagannatha032

Member Since: January 2006 Contribution: 3

RE: what is the roll of INDEX in a query?

IF YOU CREATE A PRIMARY KEY IT IS MANDATORY THAT YOU SHOULD CREATE AN INDEX FOR THAT TABLE ON THAT PRIMARY KEY,WITHOUT WHICH YOU CAN NOT ACCESS THE TABLE

Is this answer useful? Yes | No

Go To Top