cherry-pick #1783 to release-5.0
You can switch your code base to this Pull Request by using git-extras:

# In tics repo:
git pr https://github.com/pingcap/tics/pull/1790

After apply modifications, you can push your change to this PR via:

git push git@github.com:ti-srebot/tics.git pr/1790:release-5.0-c72c331726b4

What problem does this PR solve?

Problem Summary:

Currently in DT engine, we only do place index for relevant query ranges in a segment. It can speed up individual region read, but the result of place index can not be shared between other region reads. It will eventually slow down the whole query processing if we have lots of cop requests.

What is changed and how it works?

What's Changed:

1. This PR adds a new option dt_enable_relevant_place, and by default set to true, means enabling relevant place. The behavior is the same as the previous, but we can use the option to disable the relevant place.
2. Fix bug: delete range can not remove expected data

Related changes

• PR to update pingcap/docs/pingcap/docs-cn:
• Need to cherry-pick to the release branch

Check List

Tests

• Unit test
• Integration test

Side effects

Release note

• Fix a potential issue that the DeleteRange in the storage engine failed to remove some data.