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

What are the types of resultset?

1015

What are the types of lock supported by ?

1094

What does indexation mean?

1033

What are acid properties of transaction?

997

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1124

Does partitioning ssd reduce performance?

930

How to get a list of columns in a view using the "sp_columns" stored procedure?

1086

What is field in algebra?

1094

What is a trace frag?

1136

How to check table values in sql server?

1009

How to delete duplicate rows?

1039

What is a matrix in ssrs?

158

What is a raid and what are different types of raid configurations?

1325

What do you understand by replication in sql server?

1128

Describe the functionalities that views support.

1149