Disclaimer: When I wrote this I was not an employee of Oracle, a RDBMS vendor. I am now, and you should know that. I also have had to modify the original content to abide by our blogging guidelines. You’re not missing anything big or juicy, but my theory on why our eBiz solution does not [...]
database
How Many Rows will my Query Return?
You want to know how much pain you are going to inflict on the server and network before you run that ad hoc query? An explain plan can give you an idea of how long it might take to run, and tell you how much data it thinks will be involved. Cardinality – Fancy Word, [...]
They Just Write SQL Statements
“Those people are fine, they JUST write SQL.” I often hear this in the context of visiting customers and offering to provide training (and yes, software) to their database users. There is a class of people who are deemed unworthy of such productivity tools because they do nothing but ‘just write dumb SQL all day [...]
On Real-Time SQL Monitoring and the /*+MONITOR*/ Hint
Oracle 11gR1 Enterprise Edition with the Diagnostic and Tuning packs has a very compelling new feature, Real-Time SQL Monitoring. Oracle thinks enough of the feature that it was highlighted prominently in whitepaper by ACE Directory Arup Nanda titled “Oracle Database 11g: The Top Features for DBAs and Developers” (read it here) Long story short: Too [...]
I Only Use SQL*Plus, a Desperate Cry for Help?
Disclaimer: I work for Oracle now. This post pretty much pertains to any and all database IDE and GUIs. –Thanks, Jeff 1/25/2012 Let’s get this out of the way, because anyone who knows me, knows that I have a HUGE bias in this argument: I work for Quest Software, and my primary job is to [...]
Twitter
RSS
GooglePlus
Facebook