/dports/databases/percona56-client/percona-server-5.6.51-91.0/sql/ |
H A D | sql_planner.cc | 465 (idx == join->const_tables) ? in best_access_path() 1084 idx == join->const_tables && in best_access_path() 1118 if (join->const_tables == join->tables) in choose_table_order() 1266 uint idx= join->const_tables; in optimize_straight_join() 1606 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 2469 tableno != join->const_tables - 1; in fix_semijoin_strategies() 2795 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 2933 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3007 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3066 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 94 uint const_tables; ///< Number of primary tables deemed constant variable 423 const_tables= 0; in init() 480 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 486 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/sql/ |
H A D | sql_planner.cc | 465 (idx == join->const_tables) ? in best_access_path() 1084 idx == join->const_tables && in best_access_path() 1118 if (join->const_tables == join->tables) in choose_table_order() 1266 uint idx= join->const_tables; in optimize_straight_join() 1606 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 2469 tableno != join->const_tables - 1; in fix_semijoin_strategies() 2795 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 2933 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3007 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3066 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 94 uint const_tables; ///< Number of primary tables deemed constant variable 423 const_tables= 0; in init() 480 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 486 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/sql/ |
H A D | sql_planner.cc | 465 (idx == join->const_tables) ? in best_access_path() 1084 idx == join->const_tables && in best_access_path() 1118 if (join->const_tables == join->tables) in choose_table_order() 1266 uint idx= join->const_tables; in optimize_straight_join() 1606 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 2469 tableno != join->const_tables - 1; in fix_semijoin_strategies() 2795 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 2933 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3007 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3066 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 94 uint const_tables; ///< Number of primary tables deemed constant variable 423 const_tables= 0; in init() 480 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 486 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/sql/ |
H A D | sql_planner.cc | 459 (idx == join->const_tables) ? in best_access_path() 1076 idx == join->const_tables && in best_access_path() 1110 if (join->const_tables == join->tables) in choose_table_order() 1258 uint idx= join->const_tables; in optimize_straight_join() 1597 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 2460 tableno != join->const_tables - 1; in fix_semijoin_strategies() 2785 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 2923 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 2997 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3056 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 94 uint const_tables; ///< Number of primary tables deemed constant variable 423 const_tables= 0; in init() 480 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 486 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/mysql56-client/mysql-5.6.51/sql/ |
H A D | sql_planner.cc | 459 (idx == join->const_tables) ? in best_access_path() 1076 idx == join->const_tables && in best_access_path() 1110 if (join->const_tables == join->tables) in choose_table_order() 1258 uint idx= join->const_tables; in optimize_straight_join() 1597 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 2460 tableno != join->const_tables - 1; in fix_semijoin_strategies() 2785 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 2923 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 2997 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3056 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 94 uint const_tables; ///< Number of primary tables deemed constant variable 423 const_tables= 0; in init() 480 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 486 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/sql/ |
H A D | sql_planner.cc | 1933 for (uint i = 0; i < join->const_tables; i++) in choose_table_order() 1937 if (join->const_tables == join->tables) { in choose_table_order() 1939 sizeof(POSITION) * join->const_tables); in choose_table_order() 1956 merge_sort(join->best_ref + join->const_tables, in choose_table_order() 2094 uint idx = join->const_tables; in optimize_straight_join() 2420 for (uint i = join->const_tables; i < n_tables + join->const_tables; i++) { in get_partial_join_cost() 3656 if (first_tab == join->const_tables) { in semijoin_firstmatch_loosescan_access_paths() 3799 if (first_inner == join->const_tables) { in semijoin_mat_scan_access_paths() 3870 if (first_inner == join->const_tables) { in semijoin_mat_lookup_access_paths() 3919 if (first_tab == join->const_tables) { in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 184 uint const_tables{0}; ///< Number of primary tables deemed constant 559 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 565 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table() 1096 recalculate(join->const_tables); in init()
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/sql/ |
H A D | sql_planner.cc | 1168 idx == join->const_tables && in best_access_path() 1839 if (join->const_tables == join->tables) in choose_table_order() 1842 sizeof(POSITION) * join->const_tables); in choose_table_order() 2003 uint idx= join->const_tables; in optimize_straight_join() 2336 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 3260 tableno != join->const_tables - 1; in fix_semijoin_strategies() 3585 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 3744 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3820 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3880 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 75 const_tables(0), in JOIN() 224 uint const_tables; ///< Number of primary tables deemed constant variable 549 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 555 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/percona57-server/percona-server-5.7.36-39/sql/ |
H A D | sql_planner.cc | 1169 idx == join->const_tables && in best_access_path() 1840 if (join->const_tables == join->tables) in choose_table_order() 1843 sizeof(POSITION) * join->const_tables); in choose_table_order() 2004 uint idx= join->const_tables; in optimize_straight_join() 2338 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 3262 tableno != join->const_tables - 1; in fix_semijoin_strategies() 3588 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 3747 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3823 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3883 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 75 const_tables(0), in JOIN() 224 uint const_tables; ///< Number of primary tables deemed constant variable 549 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 555 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/sql/ |
H A D | sql_planner.cc | 1168 idx == join->const_tables && in best_access_path() 1839 if (join->const_tables == join->tables) in choose_table_order() 1842 sizeof(POSITION) * join->const_tables); in choose_table_order() 2003 uint idx= join->const_tables; in optimize_straight_join() 2336 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 3260 tableno != join->const_tables - 1; in fix_semijoin_strategies() 3585 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 3744 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3820 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3880 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 75 const_tables(0), in JOIN() 224 uint const_tables; ///< Number of primary tables deemed constant variable 549 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 555 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/percona57-client/percona-server-5.7.36-39/sql/ |
H A D | sql_planner.cc | 1169 idx == join->const_tables && in best_access_path() 1840 if (join->const_tables == join->tables) in choose_table_order() 1843 sizeof(POSITION) * join->const_tables); in choose_table_order() 2004 uint idx= join->const_tables; in optimize_straight_join() 2338 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 3262 tableno != join->const_tables - 1; in fix_semijoin_strategies() 3588 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 3747 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3823 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3883 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 75 const_tables(0), in JOIN() 224 uint const_tables; ///< Number of primary tables deemed constant variable 549 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 555 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/sql/ |
H A D | sql_planner.cc | 1169 idx == join->const_tables && in best_access_path() 1840 if (join->const_tables == join->tables) in choose_table_order() 1843 sizeof(POSITION) * join->const_tables); in choose_table_order() 2004 uint idx= join->const_tables; in optimize_straight_join() 2338 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 3262 tableno != join->const_tables - 1; in fix_semijoin_strategies() 3588 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 3747 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3823 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3883 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 75 const_tables(0), in JOIN() 224 uint const_tables; ///< Number of primary tables deemed constant variable 549 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 555 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/mysql57-client/mysql-5.7.36/sql/ |
H A D | sql_planner.cc | 1168 idx == join->const_tables && in best_access_path() 1839 if (join->const_tables == join->tables) in choose_table_order() 1842 sizeof(POSITION) * join->const_tables); in choose_table_order() 2003 uint idx= join->const_tables; in optimize_straight_join() 2336 for (uint i= join->const_tables; i < n_tables + join->const_tables ; i++) in get_partial_join_cost() 3260 tableno != join->const_tables - 1; in fix_semijoin_strategies() 3585 if (first_tab == join->const_tables) in semijoin_firstmatch_loosescan_access_paths() 3744 if (first_inner == join->const_tables) in semijoin_mat_scan_access_paths() 3820 if (first_inner == join->const_tables) in semijoin_mat_lookup_access_paths() 3880 if (first_tab == join->const_tables) in semijoin_dupsweedout_access_paths() [all …]
|
H A D | sql_optimizer.h | 75 const_tables(0), in JOIN() 224 uint const_tables; ///< Number of primary tables deemed constant variable 549 bool plan_is_const() const { return const_tables == primary_tables; } in plan_is_const() 555 bool plan_is_single_table() { return primary_tables - const_tables == 1; } in plan_is_single_table()
|
/dports/databases/mysql55-client/mysql-5.5.62/sql/ |
H A D | sql_select.cc | 1038 const_tables= tables; in optimize() 1516 if (const_tables != tables) in optimize() 1956 (const_tables == tables || in exec() 3136 join->const_tables=const_count; in make_join_statistics() 4961 idx == join->const_tables && in best_access_path() 5192 uint idx= join->const_tables; in optimize_straight_join() 6186 const_tables= 0; in make_simple_join() 6561 if (i != join->const_tables && join->tables > join->const_tables + 1) in make_join_select() 6981 i-join->const_tables)) in make_join_readinfo() 6997 if (i == join->const_tables) in make_join_readinfo() [all …]
|