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 is difference between views and stored procedures?

930

How do you create a data source?

869

What is snapshot parameter in ssrs?

140

How many database files are there in sql server 2000?what are they?

980

How do I install only the client tools of sql server 2000?

995

What is the difference between count () and rowcount ()?

948

Explain the disadvantages/limitation of the cursor?

917

What is entity data services?

1005

How to move database physical files in ms sql server?

961

Name and describe few console utilities for ssrs?

276

How to drop an existing user defined function in ms sql server?

982

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

884

How do I find sql server instance name?

917

Explain the properties of the relational tables?

940

What are the advantages to use stored procedures?

1034