what is index seek and index scan?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Show Practically Sql Server Views are updatable?

586


Explain difference between control flow and data flow?

527


How to generate create function script on an existing function?

587


What is SubQuery in SQL Server 2008

546


What is indexing in sql server with example?

521






What are the underflow and overflow behaviors on float literals?

572


Explain what is the use of custom fields in report?

496


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1532


What is difference between unique and primary key?

477


What is a View ? Can we insert, Update and delete a view?

627


How can you insert values in multiple rows using one Insert statement?

615


Do you know what are pages and extents? : SQL Server Architecture

548


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

486


What are points to remember while using the fillfactor argument?

528


What is the Main Difference between ACCESS and SQL SERVER?

559