Interested to Buy Any Domain ? << Click Here >> for more details...
what purpose of Indexing creating? directly we can search
the reqired row with the help of query?what is the use of
indexing?
- 3 Answers
- 13617 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhunathanv
Main Purpose of Index creation is the for the Quick
retrieval of data ie.., speed up searching, from the
Table,where by it is created in the page index ,so that
instead of searching out for whole records from the table
when the query is executed it goes to page id and finds the
index id created and retrieves out the data based on
indexid ,so that time it takes becomes less when compared
to non creation of index.
By default when index is not created primary key will be
the default index.
The sysindexes table, which exists in every database,
tracks table and index information
AFAIK
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is ole2 format?
Define data adapter?
What connected data?
What is the role of data provider in ado.net?
What is difference between Dataview and Datatable?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is a string variable?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is the difference between data reader and data adapter?
What are the essential features of ado.net?
What is the executescalar method?
How to identify the updated rows in a dataset?
Explain the difference between sqlcommand object and command behavior object?
How to load multiple tables into a dataset?
What is ole db query?
