Parent-Child Relationships and the Questions Left Unanswered by TKPROF, Re-Learning Something Old

Database Management and Performance
| Jan 29, 2012 23:00 +0000

January 30, 2012 As we have seen in the past, TKPROF output sometimes lies, and in a recent OTN thread I was reminded of another case or two where TKPROF output may be misleading.  In the OTN thread, the original poster (OP) started the thread by ask…

Non-Specific Index Hints

Database Management and Performance
| Jan 24, 2012 13:39 +0000

January 24, 2012 (Modified January 25, 2012) As I read the “Troubleshooting Oracle Performance” book for the second time a couple of months ago, I made note on page 385 that it was possible to specify table columns in an index hint, rather than s…