这样的SQL句子,SELECT ACCT_ID, EXT_ID, EXT_ID_TY, JVL_COUNT as count FROM TA_SPEAR_JVL_DATA GROUP BY ACCT_ID, EXT_ID, EXT_ID_TY, JVL_COUNT HAVING JVL_COUNT > 0
如果不用游标,如何提高速度?
如果不用游标,如何提高速度?
解决方案 »
- sqlserver 函数简单问题
- ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
- 菜鸟问个oracle 10G的enterprise manager添加数据库怎么添加呢?
- oracle full join的问题,请高手
- Oracle10g 有没有文件跟踪 sqlplus 用户的所有操作历史记录呢?
- 急 ORACLE 测试 没有反应
- 如何使用变量
- Question about Quest's shareplex
- 一个简单得不得了的问题
- 各位大哥大姐,救救小妹,关于一个简单的TRIGGER问题????:<
- 菜鸟(初学者)高分求助,进者有分,不够再加
- 根据用户输入的资料进行表查询的 存储过程怎么写?
建索引:
create index inx1 on TA_SPEAR_JVL_DATA(ACCT_ID, EXT_ID, EXT_ID_TY, JVL_COUNT );建物化视图:
create materialize view mv1
build immediate
refresh on commit
enable query rewrite
as
SELECT ACCT_ID, EXT_ID, EXT_ID_TY, JVL_COUNT as count
FROM TA_SPEAR_JVL_DATA
GROUP BY ACCT_ID, EXT_ID, EXT_ID_TY, JVL_COUNT ;
select a.acct_id,a.ext_id,ext_id_ty,a.jvl_count as count from ta_spear_jvl_data a
where a.jvl_count>0
group by a.acct_id,a.ext_id,a.ext_id_ty,a.jvl_count
列名前加表名可以减少查询数据字典的时间,在分组前应该尽量的减少分组数据量