请问下 OB的索引统计信息是看这个视图吗 select * from oceanbase.DBA_IND_STATISTICS ?我查这个视图发现没有信息在里面, 0 - output([serialcode.id(0x7f7e2a03e490)], [serialcode.uuid(0x7f7e2a03e750)], [serialcode.imei1(0x7f7e2a03ea10)], [serialcode.imei2(0x7f7e2a03ecd0)], [serialcode.meid(0x7f7e2a03ef90)], [serialcode.item_code(0x7f7e2a03f250)], [serialcode.box_no(0x7f7e2a03f510)], [serialcode.first_agent_code(0x7f7e2a03f7d0)], [serialcode.customer_code(0x7f7e2a03bcb0)], [serialcode.customer_account_code(0x7f7e2a03df50)], [serialcode.customer_warehouse_code(0x7f7e2a03ce00)], [serialcode.sku_code(0x7f7e2a03fa90)], [serialcode.machine_status(0x7f7e2a03fd50)], [serialcode.machine_type(0x7f7e2a040010)], [serialcode.stock_status(0x7f7e2a0402d0)], [serialcode.business_status(0x7f7e2a040590)], [serialcode.activation_status(0x7f7e2a040850)], [serialcode.activation_time(0x7f7e2a042aa0)], [serialcode.relation_order_no(0x7f7e2a042d60)], [serialcode.create_time(0x7f7e2a043020)], [serialcode.create_user_id(0x7f7e2a0432e0)], [serialcode.update_time(0x7f7e2a0435a0)], [serialcode.update_user_id(0x7f7e2a043860)], [serialcode.del_flag(0x7f7e2a043b20)], [serialcode.sales_hierarchy1(0x7f7e2a043de0)], [serialcode.sales_hierarchy2(0x7f7e2a0440a0)], [serialcode.sales_hierarchy3(0x7f7e2a044360)], [serialcode.sales_hierarchy4(0x7f7e2a044620)], [serialcode.buyer_id(0x7f7e2a0448e0)], [serialcode.buyer_shop_id(0x7f7e2a044ba0)], [serialcode.buyer_account_id(0x7f7e2a044e60)], [serialcode.buyer_wh_id(0x7f7e2a045120)], [serialcode.buyer_shop_type(0x7f7e2a0453e0)], [serialcode.buyer_carrier_type(0x7f7e2a0456a0)], [serialcode.seller_id(0x7f7e2a045960)], [serialcode.seller_shop_id(0x7f7e2a045c20)], [serialcode.seller_account_id(0x7f7e2a045ee0)], [serialcode.seller_wh_id(0x7f7e2a0461a0)], [serialcode.seller_shop_type(0x7f7e2a046460)], [serialcode.seller_carrier_type(0x7f7e2a046720)], [serialcode.product_brand_category(0x7f7e2a0469e0)], [serialcode.register_machine_flag(0x7f7e2a046ca0)], [serialcode.remark(0x7f7e2a046f60)]), filter([serialcode.customer_code(0x7f7e2a03bcb0) = 'CUCHN112481'(0x7f7e2a03b600)], [serialcode.customer_account_code(0x7f7e2a03df50) = 'ACTCHN111359'(0x7f7e2a03d8a0)]) access([serialcode.id(0x7f7e2a03e490)], [serialcode.customer_code(0x7f7e2a03bcb0)], [serialcode.customer_warehouse_code(0x7f7e2a03ce00)], [serialcode.customer_account_code(0x7f7e2a03df50)], [serialcode.uuid(0x7f7e2a03e750)], [serialcode.imei1(0x7f7e2a03ea10)], [serialcode.imei2(0x7f7e2a03ecd0)], [serialcode.meid(0x7f7e2a03ef90)], [serialcode.item_code(0x7f7e2a03f250)], [serialcode.box_no(0x7f7e2a03f510)], [serialcode.first_agent_code(0x7f7e2a03f7d0)], [serialcode.sku_code(0x7f7e2a03fa90)], [serialcode.machine_status(0x7f7e2a03fd50)], [serialcode.machine_type(0x7f7e2a040010)], [serialcode.stock_status(0x7f7e2a0402d0)], [serialcode.business_status(0x7f7e2a040590)], [serialcode.activation_status(0x7f7e2a040850)], [serialcode.activation_time(0x7f7e2a042aa0)], [serialcode.relation_order_no(0x7f7e2a042d60)], [serialcode.create_time(0x7f7e2a043020)], [serialcode.create_user_id(0x7f7e2a0432e0)], [serialcode.update_time(0x7f7e2a0435a0)], [serialcode.update_user_id(0x7f7e2a043860)], [serialcode.del_flag(0x7f7e2a043b20)], [serialcode.sales_hierarchy1(0x7f7e2a043de0)], [serialcode.sales_hierarchy2(0x7f7e2a0440a0)], [serialcode.sales_hierarchy3(0x7f7e2a044360)], [serialcode.sales_hierarchy4(0x7f7e2a044620)], [serialcode.buyer_id(0x7f7e2a0448e0)], [serialcode.buyer_shop_id(0x7f7e2a044ba0)], [serialcode.buyer_account_id(0x7f7e2a044e60)], [serialcode.buyer_wh_id(0x7f7e2a045120)], [serialcode.buyer_shop_type(0x7f7e2a0453e0)], [serialcode.buyer_carrier_type(0x7f7e2a0456a0)], [serialcode.seller_id(0x7f7e2a045960)], [serialcode.seller_shop_id(0x7f7e2a045c20)], [serialcode.seller_account_id(0x7f7e2a045ee0)], [serialcode.seller_wh_id(0x7f7e2a0461a0)], [serialcode.seller_shop_type(0x7f7e2a046460)], [serialcode.seller_carrier_type(0x7f7e2a046720)], [serialcode.product_brand_category(0x7f7e2a0469e0)], [serialcode.register_machine_flag(0x7f7e2a046ca0)], [serialcode.remark(0x7f7e2a046f60)]), partitions(p0) limit(1000), offset(nil), is_index_back=true, is_global_index=false, filter_before_indexback[false,false], range_key([serialcode.customer_warehouse_code(0x7f7e2a03ce00)], [serialcode.id(0x7f7e2a03e490)]), range(WHCHN111646,MIN ; WHCHN111646,MAX), range_cond([serialcode.customer_warehouse_code(0x7f7e2a03ce00) = 'WHCHN111646'(0x7f7e2a03c750)])我们发现有个执行计划索引选择错了 执行借还怎么选择索引的有没有什么文章解释下 他三个列都有索引 但选择的索引不是最优的
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
OceanBase社区版(Community Edition)中的 OCP(OceanBase Control Platform)是基于Express框架开发的。Express是一个简单而灵活的Node.js Web应用程序框架,OCP使用它来构建管理控制台。使用Express框架可以使OCP轻巧和高效,并提供了许多有用的功能和插件,使其更容易扩展和定制。
可以试试重建索引,如果不行 可以问答区发个帖,提供版本号,建表语句和查询sql,执行计划。我们看下,此回答整理自钉群“[社区]技术答疑群OceanBase”