231 Commits

Author SHA1 Message Date
b39a1ca7c0 planner: add the prefix index as candidate for topn optimization (#65533)
fix pingcap/tidb#63280
2026-01-17 14:41:28 +00:00
53dc671df4 planner: non-deterministic expression can not be pushed down throught the join (#65563)
close pingcap/tidb#65486
2026-01-15 07:05:38 +00:00
tpp
79b2debe2a planner: index pruning using existing infra (#64999)
close pingcap/tidb#63856
2026-01-15 01:11:23 +00:00
4915482a36 *: use IsColOpCol to remove the same code (#65144) 2025-12-22 10:08:23 +00:00
ce06e5d382 *: fix index lookup pushdown error for partition table + uncomitted rows (#65157)
close pingcap/tidb#65155
2025-12-22 08:30:40 +00:00
69fb8dbc92 *: support system variable tidb_index_lookup_pushdown_policy and hint NO_INDEX_LOOKUP_PUSHDOWN (#64932)
ref pingcap/tidb#62575
2025-12-15 05:38:47 +00:00
5ee17f4a1d *: support for partition table and common handle for index lookup push down (#64839)
ref pingcap/tidb#62575, close pingcap/tidb#64594, close pingcap/tidb#64595
2025-12-04 09:07:23 +00:00
47d17123d6 expression,planner: move planner-specific functions out of expression (#64675)
ref pingcap/tidb#63856
2025-11-26 01:16:05 +00:00
a97f75ba4b expression,planner: gather both prefix and full index columns at once (#64484)
ref pingcap/tidb#63856
2025-11-21 23:10:05 +00:00
4b3e59a05b *: fix incorrect rlike when quering information_schema (#64301)
close pingcap/tidb#64249
2025-11-07 17:29:44 +00:00
8b070c2231 planner: fix prefer task logic when enumerate physical limit/topn (#64151)
close pingcap/tidb#63985
2025-11-05 17:02:53 +00:00
0982aded20 Cascades optimizer: handle warning messages for inapplicable hints properly (#62737)
ref pingcap/tidb#62328, close pingcap/tidb#62736
2025-10-24 05:41:13 +00:00
0deccbba5f planner: maintain a map of columns by ID in DataSource (#64053)
ref pingcap/tidb#63856
2025-10-23 19:56:04 +00:00
d7470ffa9e planner: remove function pointers (#64077)
ref pingcap/tidb#64049
2025-10-22 08:16:49 +00:00
a00894143c planner: remove function pointer for the UnionAll/MaxOneRow/PartitionUnionAll/Sequence (#64066)
ref pingcap/tidb#52714
2025-10-21 12:16:25 +00:00
5c12eaac62 planner: remove the default implementation of exhaustPhysicalPlans of all ops. (#64011)
ref pingcap/tidb#52714
2025-10-20 11:33:04 +00:00
a93a1687d8 planner: remove some function pointers (#64015)
ref pingcap/tidb#52714
2025-10-20 09:43:01 +00:00
4dca2c06ba planner: eliminate the findBestTask func pointer for cte/cte-table/show. (#63991)
ref pingcap/tidb#52714
2025-10-16 11:08:13 +00:00
8b288a9103 planner: classify enforcer related logic into enforce.go (#63974)
ref pingcap/tidb#52714
2025-10-15 16:31:10 +00:00
aa22bdccd3 planner: eliminate the findBestTask function pointer when call for physicalization of show (#63971)
ref pingcap/tidb#52714
2025-10-15 07:44:13 +00:00
4dc983548d planner: move FindBestTask4LogicalMemTable into physicalop (#63913)
ref pingcap/tidb#52714
2025-10-14 13:16:26 +00:00
926eb2daa3 planner: remove unused variable (#63930) 2025-10-13 12:13:55 +00:00
c1297c9b33 planner: refactor FindBestTask and move FindBestTask4LogicalTableDual (#63863)
ref pingcap/tidb#52714
2025-10-10 10:45:00 +00:00
3a54eaa3ff planner: fix LogicalProjection.DeriveStats allocate too many memories (#63829)
close pingcap/tidb#63810
2025-10-09 14:34:54 +00:00
ae3d6acbb5 planner: remove code of the hint nth_plan - 1 (#63803)
ref pingcap/tidb#63802
2025-09-30 02:57:19 +00:00
8840daf482 planner, executor: support access path keep order with IN conditions using merge sort (#62694)
close pingcap/tidb#34882, close pingcap/tidb#63449
2025-09-29 16:22:16 +00:00
805da7ca66 *: move exhaustPhysicalPlan for lock/sort/topn into physicalop (#63790)
ref pingcap/tidb#52714
2025-09-29 08:07:01 +00:00
10b7c71283 planner: remove code of the deprecated optimizer trace - 4 (#63793)
ref pingcap/tidb#63725
2025-09-29 06:27:58 +00:00
eb47aabd79 planner: relocate table/index scan build logic to physical op dir (#63585)
ref pingcap/tidb#52714
2025-09-28 07:22:40 +00:00
98fa1ac0d9 planner: remove code of the deprecated optimizer trace - 2 (#63765)
ref pingcap/tidb#63725
2025-09-28 04:44:07 +00:00
933db8df82 parser, planner: Add hint INDEX_LOOKUP_PUSH_DOWN and implement the planner part (#62714)
close pingcap/tidb#62713, close pingcap/tidb#63611
2025-09-27 07:41:43 +00:00
f5234c41e8 planner: remove code of the deprecated optimizer trace - 1 (#63731)
ref pingcap/tidb#63725
2025-09-26 02:33:49 +00:00
b2f6a2c6d1 planner: fix cannot find column error for expression index (#63683)
close pingcap/tidb#52653
2025-09-25 04:48:01 +00:00
ca7e8acb3e planner: refactor outer to inner join (#63637)
close pingcap/tidb#63602
2025-09-23 07:52:16 +00:00
78ca97301b planner: refactor exhaustPhysicalPlans (#63508)
ref pingcap/tidb#52714
2025-09-16 16:40:23 +00:00
afe11b6a28 planner: rewrite semi join when to predicate push down (#63436)
close pingcap/tidb#58958
2025-09-14 17:52:54 +00:00
a4f7468af3 planner: use generator to implement the PhysicalTableDual's CloneForPlanCache (#63472)
close pingcap/tidb#63075
2025-09-11 13:12:12 +00:00
ae6d30c24f planner: re-enable the plan cache generator and move Delete/Inset/Update into physicalop (#63443)
ref pingcap/tidb#52714
2025-09-11 06:20:39 +00:00
d022959e78 planner: keep join keys for join optimization in constant propagation (#63404)
close pingcap/tidb#60076, close pingcap/tidb#63314
2025-09-10 02:07:48 +00:00
c8d2bef20e planner: move physical related logic into physical op dir (#63401)
ref pingcap/tidb#52714
2025-09-08 10:39:06 +00:00
cc619f44a9 planner: move PhysicalJoin related logic into physical op dir (#63390)
ref pingcap/tidb#52714
2025-09-08 02:58:39 +00:00
307a2c7686 planner: refactor some code related to constant propagation for join (#63388)
ref pingcap/tidb#63314
2025-09-05 12:55:36 +00:00
d75dc0b06c planner: handle firstrow columns in aggregation predicate pushdown (#63059)
ref pingcap/tidb#24853
2025-09-03 15:32:12 +00:00
91ae16cf03 planner: Add some comments about the ds.rowcount (#63302)
close pingcap/tidb#59595
2025-09-02 04:18:36 +00:00
a1183bc1cc planner: fix select lock don't have Hash64 and Equals methods itself in next-gen mode. (#63227)
close pingcap/tidb#63229
2025-08-29 10:32:04 +00:00
02d38ee4d0 planner: PropagateConstant can remove useless push down conditions (#63061)
close pingcap/tidb#62991
2025-08-28 04:32:46 +00:00
5a9d82532d planner: implement func CloneForPlanCache() for PhysicalTableDual (#63198)
ref pingcap/tidb#63075
2025-08-27 15:50:55 +00:00
50e9e88a75 planner: update the fundamental NDV scaling estimation formula (#63068)
close pingcap/tidb#54812
2025-08-27 14:03:34 +00:00
eedab0ee5a planner: clean debug code. (#63180) 2025-08-26 04:03:13 +00:00
5fab436e60 planner: use expoBackoff for GROUP BY cardinality estimation when no … (#62813)
close pingcap/tidb#62756
2025-08-25 21:16:10 +00:00