I want to know detailed analysis on index seek and index scan and its importance in tuning query and also reading and identifying each and every counter in an execution plan.