An index seek shows that the index is used in the table and index scan sho

what is index seek and index scan?

Question Posted / vasu

Answer Posted / vasu

An index seek shows that the index is used in the table and
index scan shows that index is not used in table

Is This Answer Correct ?

8 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Do comments need to go in a special place in sql server 2005?

850

Can we add an identity column to decimal datatype?

991

Can foreign key be deleted?

918

Explain the xml support sql server extends?

1032

What do you understand by SQL*Net?

1013

What are wait types?

1100

Can you explain what is the use of custom fields in report?

1052

What are recommended options to be used while using db mirroring? : sql server database administration

1144

Can we update data in a view?

1021

What is the benefit of normalization?

1074

What is Extended user-defined?

952

List out what other servers you can use with ssrs?

137

Scalability, Availability, Integration with internet, etc.)?

2874

how to avoid cursors? : Sql server database administration

966

Mention the different types of replication in sql server.

1014