Alibabacloud Polardbx Sql

v0.0.2

Design partition schemes, select partition keys, create GSI, and write SQL for PolarDB-X 2.0 Enterprise Edition AUTO mode databases, handling PolarDB-X vs MySQL differences (partitioned tables, GSI, CCI, Sequence, table groups, TTL, pagination, etc.). Use when designing partition schemes, selecting partition keys, converting single tables to partitioned tables, creating GSI/CCI indexes, writing or migrating SQL for PolarDB-X, or diagnosing slow queries on PolarDB-X. Triggers: "PolarDB-X SQL", "PolarDB-X create table", "partitioned table", "partition design", "partition scheme", "partition key", "GSI", "CCI", "Sequence", "MySQL migrate to PolarDB-X", "PolarDB-X compatibility", "single table to partitioned table", "convert to partitioned table", "large table", "table sharding", "distributed table", "AUTO mode", "pagination query", "Keyset pagination", "Range partition", "auto add partition", "PolarDB-X slow query", "full-shard scan"

0· 222·0 当前·0 累计
sdk-team 头像by @sdk-team (alibabacloud-skills-team)·MIT-0
下载技能包
License
MIT-0

License

MIT-0

可自由使用、修改和再分发,无需署名。

运行时依赖

无特殊依赖

版本

latestv0.0.2

references/pagination-best-practice.md Efficient pagination: Keyset pagination, per-shard traversal, index requirements, Java examples

安装命令

点击复制
官方npx clawhub@latest install alibabacloud-polardbx-sql
镜像加速npx clawhub@latest install alibabacloud-polardbx-sql --registry https://cn.longxiaskill.com 镜像可用
需要定制?告诉我你的需求 →
数据来源ClawHub ↗ · 中文优化:龙虾技能库