SELECT a.sys_corpus_cd as sysCorpusCd
, a.assign_cnt as assignCnt
, a.reg_date as regDate
, a.version_id as versionId
FROM sys_corpus a, corpus_version b
WHERE a.stat = 'working'
AND a.version_id = b.version_id
AND b.valid_flg = 'Y'
AND a.assign_cnt < 2
AND a.sys_corpus_cd NOT IN (
SELECT c.sys_corpus_cd
FROM user_corpus c, user d, corpus_version e
WHERE c.user_cd = d.user_cd
AND e.version_id = c.version_id
AND e.valid_flg = 'Y'
AND d.id = 'xxxx' )
ORDER BY a.sys_corpus_cd;外层SQL数据量大概在90万条.
NOT IN里面的大概在1万条左右(以后还会增长).
有什么好解决方法吗?
, a.assign_cnt as assignCnt
, a.reg_date as regDate
, a.version_id as versionId
FROM sys_corpus a, corpus_version b
WHERE a.stat = 'working'
AND a.version_id = b.version_id
AND b.valid_flg = 'Y'
AND a.assign_cnt < 2
AND a.sys_corpus_cd NOT IN (
SELECT c.sys_corpus_cd
FROM user_corpus c, user d, corpus_version e
WHERE c.user_cd = d.user_cd
AND e.version_id = c.version_id
AND e.valid_flg = 'Y'
AND d.id = 'xxxx' )
ORDER BY a.sys_corpus_cd;外层SQL数据量大概在90万条.
NOT IN里面的大概在1万条左右(以后还会增长).
有什么好解决方法吗?
解决方案 »
- linux(suse)重装mysql失败
- 刚写mySQL,求教
- 在mysql的存储过程中是否可以使用PREPARE来动态执行SQL语句进行数据表数据的插入.
- mysql登录问题?
- 请问,在oracle里面的to_char和to_number这两个函数在mysql是什么
- 关于MySQL在Win2000下无法启动的问题.
- 请问这句什么意思mysql>flush privileges;
- 组合索引问题请教
- MySQL实现查询数据并计算后,把多行数据显示在一行
- 请大神关于mysql 查询语句优化建议,现在查询需要10s中才能查询完
- Can't connect to local MySQL server through socket 求助!
- 存储过程变量赋值不灵了?
索引情况是什么
但是效率上提高了只有1秒.
后来我看执行计划. 第一次查询大数据的表才导致查询速度慢的问题.
反正问题已经解决了. 谢谢.