what purpose of Indexing creating? directly we can search the reqired row with

what purpose of Indexing creating? directly we can search
the reqired row with the help of query?what is the use of
indexing?

Question Posted / sharfuddin

3 Answers
13622 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what purpose of Indexing creating? directly we can search the reqired row with the help of query?wh..

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

what purpose of Indexing creating? directly we can search the reqired row with the help of query?wh..

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

what purpose of Indexing creating? directly we can search the reqired row with the help of query?wh..

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

Post New Answer

More ADO.NET Interview Questions

What are typed and untyped dataset?

0 Answers

What does datareader object do?

0 Answers

What is namespace in ado.net?

0 Answers

How many commands does the oledbcommand takes?what are they?

2 Answers

Which is faster datareader or dataadapter?

0 Answers

How to check if a datareader is closed or opened?

1 Answers

What are the difference between readonly vs. Const?

0 Answers

What is the provider and namespaces being used to access oracle database?

4 Answers Microsoft,

Compare Data Reader & Dataset in ado.net?

0 Answers MaxSolPro,

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

0 Answers

What are the steps in connecting to database?

3 Answers IBM, Microsoft,

What is openrowset?

0 Answers

For more ADO.NET Interview Questions Click Here