what purpose of Indexing creating? directly we can search
the reqired row with the help of query?what is the use of
indexing?

Answer Posted / madhunathanv

Apart from Clustered index def:

Indexes should be used to the column where frequently data
is retrieved.

AFAIK

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is the feature of ado.net?

517


What are the advantage of ado.net?

515


What is data relation?

498


What is difference between dataset and datatable?

511


What is the difference between Data adaptor and Data set?

511






how we can fire event in databound coulm in datagfrid withot using button?

567


What are the different methods by which we can populate a dataset?

680


how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

576


Which method in OLEDBAdapter is used to populate dataset with records?

559


Explain what is datagrid with an example?

582


What are the differences between OLEDB and SQLClient Providers?

559


What is difference in record set and dataset?

530


What is full form of ado?

533


What is sqldatareader in ado.net?

497


Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

525