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
- 13647 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 are the disadvantages of using datalist?
What is the default Timeout for SqlCommand.CommandTimeout property?
Do we use stored procedure in ADO.Net?
What is maximum pool size in ado.net connection string?
What is the difference between OLEDB Provider and SqlClient?
What is data relation in ado.net?
What is difference between executequery and executeupdate?
Explain advantages of ado.net?
Define partial class?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
What do you mean by ‘batch updates’?
Which method is used to sort the data in ADO.Net?
Can we connect two dataadapters to same data source using single connection at same time?
Some important instruction regarding ADO.NET connection string ?
How to read data with the sqldatareader ?
