Thank you very much for the info! =)
Have a Great Weekend,
From: Kevin Stern [mailto:bounce-KevinStern@toadworld.com]
Sent: Thursday, January 29, 2015 12:49 PM
Subject: RE: [SQL Optimizer for Oracle - Discussion Forum] SQL Rewrite Messages
RE: SQL Rewrite Messages
Reply by Kevin Stern
Those are Oracle optimizer hints that are being applied to the SQL statement. They influence how the optimizer chooses the physical path for gathering the data. You can think of them as an “override”
for the optimizer’s default behavior. In certain cases, this can result in significant performance improvements.
If you want to learn more about SQL Optimizer’s use of hints (and the other methods it uses for optimization) - this Tech Brief is a good place to start.
Oracle also has documentation of the different hints that are available. Here is a section on the hints for 11.2.
Please let us know if you have any other questions!
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from SQL Optimizer for Oracle - General notifications altogether.
SQL Optimizer for Oracle - Discussion Forum
this post as spam/abuse.