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
- 13737 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
How to check if a datareader is closed or opened? IsClosed()
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What does datareader object do?
What is the role of clr?
What is difference between dataset and datatable?
What is difference between datareader and dataadapter?
Compare Data Reader & Dataset in ado.net?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is an ado?
What is the hierarchy of data in databases?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What is the role of data provider in ado.net?
Which is faster dataset or datareader?
What is ole in excel?
How to generate a single aggregate?
