21 lines
519 B
Plaintext
21 lines
519 B
Plaintext
#
|
|
# Test of pushed joins, aka SPJ, or AQL.
|
|
# (Test with defaults + 'batched_key_access=on')
|
|
#
|
|
# NOTE: BKA will turn of lots of pushed join, we
|
|
# are unsure if this is the best strategy, or
|
|
# if its better/possible to sacrify the BKA
|
|
#
|
|
|
|
--source include/have_ndb.inc
|
|
if (!`select locate('batched_key_access', @@global.optimizer_switch) > 0`)
|
|
{
|
|
skip Need batched_key_access;
|
|
}
|
|
|
|
set @@global.optimizer_switch='batched_key_access=on';
|
|
|
|
--source ndb_join_pushdown.inc
|
|
|
|
set @@global.optimizer_switch=default;
|