摘要：
19.1 Overview of Optimizer Hints A hint is an instruction to the optimizer. In a test or development environments, hints are useful for testing ... 阅读全文
posted @ 2015-07-20 09:25
神之一招
阅读(189)
评论(0)
推荐(0)
摘要：
16.1 Introduction to SQL Tuning Identifying high load or top SQL statements that are responsible for a large share of the application workload and ... 阅读全文
posted @ 2015-07-20 09:24
神之一招
阅读(269)
评论(0)
推荐(0)
摘要：
正常配置一下, 就OK了, 不用理了, oracle 11g 默认启动发展: 1、从Oracle的发展角度来看，估计这种方法是Oracle发展和改进的方向，如今outline已经被废弃，sql profile 估计在后续的发行版本中也难有改进，因此，对于从11g开始接触O... 阅读全文
posted @ 2015-07-20 09:23
神之一招
阅读(426)
评论(0)
推荐(0)
摘要：
do not build indexes unless necessary. 索引是非常占资源的To maintain optimal performance, drop indexes that an application is not using. 不用的索引可以drop掉, 通过toad可以... 阅读全文
posted @ 2015-07-20 09:22
神之一招
阅读(151)
评论(0)
推荐(0)
摘要：
The row source tree is the core of the execution plan. The tree shows the following information: An ordering of the tables referenced by the statem... 阅读全文
posted @ 2015-07-20 09:21
神之一招
阅读(310)
评论(0)
推荐(0)
浙公网安备 33010602011771号