数据库相关
Slowdowm
这个作者很懒,什么都没留下…
展开
-
索引优化分页
原sql: select * from ( select a.*,rownum rn from (select * from product a where company_id=? order by status) a where rownum10; 优化: 优化原理是通过纯索引找出分页记录的ROWID,再通过...原创 2010-12-27 18:57:39 · 125 阅读 · 0 评论 -
程序员应当掌握的数据库知识
http://blog.csdn.net/yzsind/archive/2010/12/06/6059209.aspx原创 2010-12-27 19:00:33 · 162 阅读 · 0 评论 -
mysql手册
http://dev.mysql.com/doc/refman/5.1/zh/preface.html原创 2010-12-27 19:41:11 · 113 阅读 · 0 评论 -
Oracle无权限误删回滚
declare 2 cursor flash_recover is 3 select * from crm_tqms_sample 4 ; 5 t_recode crm_tqms_sample%rowtype; 6 begin 7 DBMS_FLASHBACK.ENABLE_AT_TIME(to_date('2010-12-14 20:00:00','yyyy-mm-dd ...原创 2010-12-30 17:58:38 · 170 阅读 · 0 评论