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

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1990

What are the main sources of data?

1142

Explain raiserror in sql server?

1075

Give me a SQL Query to find out the second largest company?

1227

How to modify existing triggers using "alter trigger"?

1061

How to resolve the orphan use problem? : sql server security

1068

What are translations and its use? : sql server analysis services, ssas

1078

What is the user of Primary key?

1029

What are commonly used mssql functions in php?

1140

Can we check locks in database? If so, how can we do this lock check?

984

Explain timestamp datatype?

1017

What is the standby server?

998

How to view the error log for any specific instance? : sql server database administration

1093

How to convert a table data in XML format in sql server?

2591

What is executereader?

998