请问外表查询的执行计划是怎样的
obclient(SYS@admin)[SYS]> explain route select * from table_ex1 where id = 1\G;
*************************** 1. row ***************************
Route Plan:
Trans Current Query:“explain route select * from table_ex1 where id = 1”
Route Prompts
ROUTE_INFO
[INFO] Will do table partition location lookup to decide which OBServer to route to
TABLE_ENTRY_LOOKUP_DONE
[INFO] No available entry because table entry lookup failed
ROUTE_INFO
[INFO] Will route to cached connected server(172.18.8.62:2881)
ROUTE_POLICY
[INFO] All OBServers are treated as the SAME_IDC with OBProxy because ‘proxy_idc_name’ is not configured
Route Plan
SQL_PARSE:{cmd:“COM_QUERY”, table:“TABLE_EX1”}
ROUTE_INFO:{route_info_type:“USE_PARTITION_LOCATION_LOOKUP”}
LOCATION_CACHE_LOOKUP:{mode:“oceanbase”}
TABLE_ENTRY_LOOKUP_START:{}
FETCH_TABLE_RELATED_DATA:{table_entry:“partition information does not exist”}
TABLE_ENTRY_LOOKUP_DONE:{is_lookup_succ:true, entry_from_remote:false}
ROUTE_INFO:{route_info_type:“USE_CACHED_SESSION”, svr_addr:“172.18.8.62:2881”}
ROUTE_POLICY:{route_policy:"", chosen_server:“Invalid”}
CONGESTION_CONTROL:{svr_addr:“172.18.8.62:2881”}
1 row in set (0.007 sec)
ERROR: No query specified
似乎是按照没有解析出信息后按照规则查询的