--1、编辑kingbase.conf,重启服务 shared_preload_libraries值里添加'sys_qualstats' sys_stat_statements.track='top' sys_qualstats.sample_rate=1 --2.创建sys_hypo, sys_qualstats插件: create extension sys_hypo; create extension sys_qualstats; --3.创建表,执行带过滤条件的SELECT语句: create table t1(id int, name text); INSERT INTO t1 SELECT (random() * 1000000)::int, md5(g::text) FROM generate_series(1, 1000000) g; select * from t1 where id = 15678; --4.查询sql优化建议 select * from index_recommendation_by_qual ; |
KESV8 R6查询sql优化建议
最新推荐文章于 2024-05-31 12:37:18 发布