Sriram Ramamurthy Mohan – May be the Next Evangelist…!

                I am new to Orion Systems Integrators cochin. Here I found an enthusiastic person Sriram who is well versed in SQL server Performance Tuning. The way he learned SQL   is the very good.He is always look deeper into the subjects. I got only a few days to work with him. That was a wonderful Experience. Now he is leaving the company. I think he will become an MVP (Microsoft Most Valuable Professional) or Microsoft Evangelist soon. I wish him all the best for Future endeavors. I ask u to start a blog and share the information to the Public.

All the best …sriram

SQL SERVER – INDEX SEEK AND INDEX SCAN

During the examination of SQL Server execution plan you may come across Index scan and seek in the execution plan. Here I am giving small description about the Index seek and Index scan.

  • INDEX SCAN:

   The index scan will scan all the data in the data page. Index scan is useful if the table has small amount of datasets. The index scan can be considered as a table scan.

  • INDEX SEEKS:

            The index seek is good at performance optimization point of view. Index seek will only seek for the satisfying query conditions. I will write more on Performance tuning later.