KALIA

• Oct 29th, 2005

 

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

Syam

• Dec 2nd, 2005

 

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

pradipta

• Feb 3rd, 2006

 

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.

  

pjagannatha032

 Profile Answers by pjagannatha032 

• Feb 18th, 2006

 

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