Saturday, October 19, 2013

SQL Hints & Features Revealed!

Several months ago I squirreled this link away for later, and now that I have some time to catch up on it I'm really blown away by how much Tanel shares with us in this rather straightforward article.  I've read quite a few SQL explain plans over the past 7 years, but I've never had occasion to run into the tables V$SQL_HINT or V$SQL_FEATURE and this starts to open up the rabbit hole for us a bit with the scripts that Tanel shares here by showing us all of the possible hints and what they are used for.  Once I get up on my SQL skills a little more, this is likely the next destination to start understanding more about what the CBO is up to and what is possible to get out of it.

No comments:

Post a Comment