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

Explain which name space is used to get assembly details?

711


Which architecture does Datasets follow?

793


Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

763


What is Serialization in .NET? what are the types of Serialization?

768


What is a column variable?

691


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?

780


Explain advantages of ado.net?

806


What is the return type of executescalar?

710


What is ado asp?

750


How to read data with the sqldatareader ?

740


Explain the two fundamental objects in ado.net?

680


What is data control techniques?

694


What is defaultview in datatable?

783


What is bubbled event?

723


What is the purpose of using adodb?

694