Logo 
Search:

SQL FAQ

Submit Interview FAQ
Home » Interview FAQ » SQLRSS Feeds

How can you avoid a full-table scan?

  Shared By: Shruti Sharma    Date: Dec 21    Category: SQL    Views: 1214

Answer:

A full-table scan can be avoided by creating an index or rearranging the conditions in an SQL statement that are indexed.

Share: 
 
 
 
 

Didn't find what you were looking for? Find more on How can you avoid a full-table scan? Or get search suggestion and latest updates.


Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: