New Oracle10g SQL optimizer hints

Friday Apr 30th 2004 by DatabaseJournal.com Staff
Share:

With each new release of Oracle, there are more tuning controls and opportunities for improving the execution speed of SQL.

[From Builder.com]

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.

The article continues at http://builder.com.com/5100-6388-5198068.html?tag=sc

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved