Btw, if you are very new to SQL and don't even know what is an index, what is the real use of an index in a table, and how to create and drop an index then you should first go throughthese free SQL coursesto start with. It's one of the best resources to learn SQL fundamental...
Btw, if you are not familiar with what is an index and how to create and drop an index, then I suggest you first go through thesefree SQL and Database coursesto learn those basics. Difference between table scan, index scan, and index seek in Database In this article, we'll go throug...