Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: PCTP 随堂小测验选项是不是会产生歧义?
Option A is not easy to cause ambiguity?
- Non-
int
types (such as varchar, datetime, etc.), bigint
types
- Non-
int
types, non-bigint
types
My understanding is:
SHARD_ROW_ID_BITS is used to scatter row IDs so that they are not stored sequentially in a single region.
PRE_SPLIT_REGIONS sets the number of pre-allocated regions. When creating a new table with PRE_SPLIT_REGIONS=5, the total number of regions is 32. Even if the table has no data, 32 empty regions will be allocated for it.