Separate last indexed cache lookup into different transaction to reduce retries