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
- 13768 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
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What are the parameters that control most of connection pooling behaviors?
Can datareader hold data from multiple tables?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
Explain the difference between data reader and data set?
Does dapper use ado.net?
What is a column variable?
What are the benefits of ADO.NET?
What is ado in agriculture?
What is sql connection in ado.net?
What are the ado.net components?
Explain how do you connect to sql server database without using sqlclient?
What are the objects of ado.net?
Can we load multiple tables in a dataset?
What is execute reader in ado.net?
