Error in usage of indexes for query optimization was fixed.