<< 2006年11月17日 | 首页 | 2006年11月19日 >>

Oracle SQL 优化

Oracle SQL 优化

阅读全文……

标签 :

Guard against performance issues when using Oracle9i hints and views

Used separately, hints and views are terrific tools for Oracle tuning. But used together, they can cause severe performance problems. Let’s look at what hints, views, and materialized views can do for you. Then, we'll consider when and how to use them.

阅读全文……

标签 :

Three ways to speed up SQL execution in Oracle

Oracle provides several methods for reducing the time spent parsing Oracle SQL statements, which can cause a drag on performance when executing complex queries with a large number of possible execution plans. Let’s briefly examine some of these methods.

阅读全文……

标签 :

New Oracle10g SQL optimizer hints

With each new release of Oracle, there are more tuning controls and opportunities for improving the execution speed of SQL. In an article about speeding up SQL execution in Oracle, I discussed some common SQL tuning hints and, in another article, I warned about performance issues when using SQL hints inside views.


 


Oracle tuning with hints has always been complex, and the Oracle Technical Network has a great overview into the processes of using hints to tune Oracle SQL. With the introduction of 10g database, there are many new optimizer hints available to control the optimizer behavior. Let’s take a quick tour of these powerful new hints:

阅读全文……

标签 : ,