???
- 不在索引上的筛选条件要不要加
- where条件的顺序是否有影响
Explain
https://blog.csdn.net/OceanBaseGFBK/article/details/118304764
EXPLAIN 命令完整的语法是:
1 2 3
| {EXPLAIN | DESCRIBE | DESC} [BASIC | OUTLINE | EXTENDED | EXTENDED_NOADDR | PARTITIONS | FORMAT = {TRADITIONAL| JSON}] {SELECT statement | DELETE statement | INSERT statement | REPLACE statement| UPDATE statement}
|
OceanBase分区
分区表使用建议