obclient(root@t_mysql)[test]> show variables like ‘%baseline%’;
±-------------------------------------±------+
| Variable_name | Value |
±-------------------------------------±------+
| optimizer_capture_sql_plan_baselines | ON |
| optimizer_use_sql_plan_baselines | ON |
±-------------------------------------±------+
2 rows in set (0.002 sec)
obclient(root@t_mysql)[test]> select id,name,age from sbtest1 where id<100000 and name =‘margaret’ and age<18;
select id,name,age from sbtest1 where id<300000 and name =‘Margaret’ and age<18;Empty set (0.011 sec)
obclient(root@t_mysql)[test]> select id,name,age from sbtest1 where id<300000 and name =‘Margaret’ and age<18;
Empty set (0.014 sec)
obclient(root@t_mysql)[test]>
obclient(root@t_mysql)[test]> SELECT * FROM oceanbase.DBA_SQL_PLAN_BASELINES;
Empty set (0.001 sec)