| SQL optimizer [message #188032] |
Wed, 16 August 2006 17:33  |
staann56
Messages: 136
Registered: May 2006
Location: atlanta
|
Senior Member |
|
|
does anyone know of a good SQL optimizer utility?
Thanks,
Stan
|
|
|
|
|
|
| Re: SQL optimizer [message #188035 is a reply to message #188032] |
Wed, 16 August 2006 18:26  |
staann56
Messages: 136
Registered: May 2006
Location: atlanta
|
Senior Member |
|
|
The sarcasm in your reply is completely uncalled for! What a jerk!
I guess Oracle deploys mythical software….I won’t download the Oracle SQL Developer because I thought it would magically write all of the code for me.
I’m just looking for a tool that would help aid in the development process while learning how to code efficient SQL.
Thanks,
Stan
|
|
|
|
|
|
| Re: SQL optimizer [message #188037 is a reply to message #188032] |
Wed, 16 August 2006 18:42 |
staann56
Messages: 136
Registered: May 2006
Location: atlanta
|
Senior Member |
|
|
1) I'm getting the correct answer! So don't assume I'm not.
2) Trying to make if faster, hence the request for an optimizer!
IE: I have a query that runs in about 20 seconds and by using the hint /*+ ordered */ it now runs in 1 second. Just looking to further optimize my code.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: SQL optimizer [message #188565 is a reply to message #188037] |
Sat, 19 August 2006 15:12 |
 |
Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
|
What version of Oracle are you using? Do you use dbms_stats at frequent intervals, so that the cost-based optimizer (CBO) has current statistics to use for selecting the optimum execution plan? With a few exceptions, hints are unnecessary. If you have current statistics, Oracle should be able to choose the best plan on its own. Providing hints is kind of like manually shifting gears in a car with automatic transmission. However, if you are using an older version with outdated statistics, then you may need those hints.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
