In general indexes contains all the table rows. However, In few scenarios, in multiple queries we might be using same condition and operates on same set of rows. Consider the Sales data, often we will interact with data of current year only. In that cas...