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 diifferences between the ms sql server vs mysql?

756

Explain features of analysis services?

607

What is difference between clustered and non clustered index?

604

How to defragment table indexes?

630

When you should use a low fill factor?

627

What is a data source file?

580

what is unique and xaml nonclustered index

663

How many tables can be joined in SQL Server?

667

What is the openxml statement in sql server?

620

What is ms sql server reporting services?

616

What is ssl in sql server?

630

Explain syntax for dropping triggers?

626

How real and float literal values are rounded?

696

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

598

What are the differences between ms sql server & oracle?

636