1、问题描述
select depart,acc_id from
(SELECT distinct depart,
REGEXP_SUBSTR(acc_id, '[^,]+', 1, LEVEL) AS acc_id
FROM table
CONNECT BY REGEXP_SUBSTR(acc_id , '[^,]+', 1, LEVEL) IS NOT NULL) t
where t.acc_id ='';
数据库结构
当数据库中有8条数据时,上述sql竟然执行了50多秒;
2、解决方案
将数据存储改成以下
sql修改为:
select distinct depart,acc_id from table t where acc_id =''"
最后两个sql实现的效果一致