Quote:
Originally Posted by Druid_Elf
DBA's don't design the database, thats the job of the developers 
In our company DBA tasks are mostly create database, disaster recovery, space management and database migrations / security
We do the design .. But I hate people who don't have a concept of well tuned query.. I'd like to hit them in the head with an oracle guide but apparently that's illegal
So as a golden rule: At least make an explain plan of your query then run if it is any good.. If not, PLEASE STEP AWAY FROM YOUR PC  |
Assuming a query IS as well tuned as it can be, then the next logical step is to use that Explain to create new indexes and statistics. Sometimes when you have bureaucratic DBAs, you kind of have to walk them thru the process!