what purpose of Indexing creating? directly we can search
the reqired row with the help of query?what is the use of
indexing?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / d. shyamala
Indexing is helpful when you have data which is used for
retrieval rather than transactions. Indexing results in
quick retrieval of data. But Indexing should be minimized
in the database where you have lots of transactions.
Indexes are of two types Clustered and non-clustered.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
what is different between SqlCommand object and Command Behaviour Object
ADO and ADO.NET differences ?
What is the difference between ado.net and oledb?
Which ado.net object is very fast in getting data from the database?
What are the different namespaces used in the project to connect the database?
Which parameter of ConnectionString is used to specify the name of the database?
How will you fill the gridview by using datatable object at runtime?
How to get the new oledb connection of oracle in database programming?
What are all the commands used with Data Adapter?
What are the three Ado objects?
6 Answers Microsoft, StarSoft,