2013.12.10SQL性能优化

最新推荐文章于 2019-06-16 21:37:04 发布

haiross

最新推荐文章于 2019-06-16 21:37:04 发布

阅读量918

点赞数

分类专栏： Oracle资料待完成

本文链接：https://blog.youkuaiyun.com/haiross/article/details/17243417

版权

Oracle资料待完成专栏收录该内容

51 篇文章

订阅专栏

Oracle中可被并行化执行的SQL操作

http://www.askmaclean.com/archives/oracle%E4%B8%AD%E5%8F%AF%E8%A2%AB%E5%B9%B6%E8%A1%8C%E5%8C%96%E6%89%A7%E8%A1%8C%E7%9A%84sql%E6%93%8D%E4%BD%9C.html

Oracle SQL性能优化专题

http://www.askmaclean.com/archives/oracle-sql-tuning.html

[Oracle]-[SORT AGGREGATE]-count与索引

http://blog.youkuaiyun.com/bisal/article/details/9138577

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 2 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 142 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 144 0 1

SQL trace

oracle 直方图谷歌

http://blog.itpub.net/22664653/viewspace-671681

索引的特性与优化

http://blog.youkuaiyun.com/zengmuansha/article/details/5224478

Oracle 优化器的执行计划了解（1）

http://blog.youkuaiyun.com/zengmuansha/article/details/7453805

http://blog.youkuaiyun.com/zengmuansha/article/details/7642642

说明一点要做好表信息分析收集工作

拨开Oracle优化器迷雾探究Histogram直方图之秘

https://blogs.oracle.com/askmaclean/entry/%E6%8B%A8%E5%BC%80oracle%E4%BC%98%E5%8C%96%E5%99%A8%E8%BF%B7%E9%9B%BE%E6%8E%A2%E7%A9%B6histogram%E4%B9%8B%E7%A7%98