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

Define union, union all, minus, intersect?

958

What happens if null values are involved in boolean operations?

967

Do you know what are the differences between lost updates and uncommitted dependencies?

1053

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1012

how to use DTS package in 2000,2005,2008 in sql server

1818

Mention the differences between substr and charindex in sql server.

1023

How use inner join in sql server?

1102

Mention the 3 ways to get a count of the number of records in a table.

960

What are null values in ms sql server?

1058

Difference between 2NF &3NF ?

1069

What is use of except clause? How it differs from not in clause?

1001

How to write a query with a left outer join in ms sql server?

960

What are commit and rollback in sql?

1097

how would you improve etl (extract, transform, load) throughput?

1006

Tell me what is normalization? Explain different forms of normalization?

1015