kyle HaileyMay 5, 20142 minRight Deep, Left Deep and Bushy Joins in SQLWhat is right deep verses left deep? Good question. In join trees (not VST) the object on the left is acted upon first then the object on...
kyle HaileyJan 3, 20144 minCritical importance of data visualizationphoto by David Blackwell. Not sure if you can imagine or have ever experienced a meeting where you bring in your statspack or AWR report,...
kyle HaileyAug 23, 20132 minLatency Heat Maps in SQL*PlusThis is so cool ! The above is so cool. The graphic shows the latency heatmap of “log file sync” on Oracle displayed in SQL*Plus!...
kyle HaileyNov 20, 20091 minGraphics vs Text : Picture superiority effectAccording to the picture superiority effect, concepts are much more likely to be remembered experientially if they are presented as...
kyle HaileyOct 22, 20092 minDesigners Need Creativity, Understanding, SolutionsTwo interesting links 1. Overtime working at Flickr during startup days probably was ineffectual: http://www.fastcompany.com/blog/cliff-k...
kyle HaileySep 4, 20091 minDiff’ing Explain PlansDiff’ing explain plans is difficult and tedious.>Here is a new package function from Oracle for diff’ing explain plans...