Welcome to the SQL Optimizer for Oracle Community!
Online Users: 5 guest(s), 0 user(s).
This community is for you to share information with others who are striving to improve the performance of their databases through SQL optimization and index generation. Here you can access whitepapers and technical documents about SQL optimization, and download product updates. You can also share your knowledge with other users and communicate with the SQL Optimizer development team about the features and functionality of Quest SQL Optimizer for Oracle and offer suggestions and enhancements.
Join Discussion
-
Forums
Join a Discussion ForumMost Recent Discussions Force to create an explain plan even if a public QUEST_SL_EXPLAIN exist.
"Hi We are using the last version of sqlOptimiser for Oracle(8.5.0.2033)Our..." RegisL, TodayForce to create an explain plan even if a public QUEST_SL_EXPLAIN exist.
"Hi We are using the last version of sqlOptimiser for Oracle(8.5.0.2033)Our..." RegisL, 1/19/12What is the impact of ANSI SQL Format?
"I have a client that prefers SQL be written in ANSI SQL format (JOIN table On ...) but when I use..." sechase_968, 12/27/11What exactly is the benefit when || '' is added?
"The Optimizer is adding || ''. What exactly is the benefit when ||' ' is..." sechase_968, 12/16/11Failing to generate explain plan for query with SQL model operation
"Using 8.5.0.2031 and trying get performance data for Oracle 10g SQL that contains the MODEL..." alexander.haralampiev_1232388, 12/5/11All Forums...
Knowledge & Expertise
Check out our library for more information on SQL Optimizer for Oracle, including articles, tutorials, news, and videos.
-
Video Tutorials
Click the "Full Screen" button for the best viewing experience.
Tips and Tricks
Performance Improvement Expectation
by Rene Woody
This tip covers the expectation that Quest SQL Optimizer will always be able to improve the performance of your SQL statements.
Post Date: Tuesday, 13 April 2010 | View all Tips and Tricks



