Which is faster? <> or Between
All I said was, I do not need DBA sit besides me when I run explain
plan. Actually, I do not even run explain plan, I just use tools that would
do that for me when I feel like it.
Like I've said, when it comes to query tuning, I am perfectly capable of
doing it without DBA's assistance. The reverse is not true - they will
usually ask a developer for help if there is a performance issue beyond
anything obvious like lost index or broken stats. And it's the developer
who recommends best index types, and partitioning, and histograms, etc - not
because our DBAs are stupid, but because developers know the application and
the data much better.
Yes, I know there are DBAs out there who are actively involved in the
development process and know the application and the data. I worked with a
couple of them, I used to be a MSSQL DBA myself, but in Oracle world it is a pretty rare beast.
The key word is rarely :-) - exactly my point.
Not by my choice :-)
|