Index Seek vs Index Scan in SQL Server : <p>Please explain the difference between Index Scan and Index Seek in MS SQL server with an sample example, since it will be helpful to know, what's the real use of it. Thanks in advance. </p>
