The first session was on “Five Hints for Optimizing SQL”. The emphasis was very much on “shaping the query plan” to help the optimizer make the right decisions, not trying to determine every single join and access structure etc.
In the past I’ve seen Jonathan do sessions on hints, which made me realise how badly I was using them. As a result of that I found myself a little scared by them and gravitating to this “shaping” approach, but my version was not anywhere near as well thought out and reasoned as Jonathan’s approach. It’s kind-of nice to see I was on the right path, even if my approach was the mildly pathetic, infantile version of it. 🙂
The second session was on “Creating Test Data to Model Production”. I sat there smugly thinking I knew what was coming, only to realise I had only considered a fraction of the issues. I think “eye opening” would be the phrase I would use for this one. Lots of lessons learned!
I must say, after nearly 20 years (19 years and 11 months) in the game, it’s rather disconcerting to feel like such a newbie. It seems to be happening quite a lot recently. 🙂
The next event will be on the 1st September with Christian Antognini, so put it in your diary!
Cheers
Tim…
Oracle Midlands : Event #10 Summary : https://t.co/6dkwSjvNtF CC: @JLOracle @OracleMidlands @RedStackTech #ClubOracle #OM10
RT @oraclebase: Oracle Midlands : Event #10 Summary : https://t.co/6dkwSjvNtF CC: @JLOracle @OracleMidlands @RedStackTech #ClubOracle #OM10
Oracle Midlands : Event #10 Summary @oraclebase http://t.co/lm67wHCmhf #OrclDBA #odtug
RT @oraclebase: Oracle Midlands : Event #10 Summary : https://t.co/6dkwSjvNtF CC: @JLOracle @OracleMidlands @RedStackTech #ClubOracle #OM10
Oracle Midlands : Event #10 Summary http://t.co/PF56iUS2qD #oracle
RT @oraclebase: Oracle Midlands : Event #10 Summary : https://t.co/6dkwSjvNtF CC: @JLOracle @OracleMidlands @RedStackTech #ClubOracle #OM10
RT @orana: Oracle Midlands : Event #10 Summary http://t.co/PF56iUS2qD #oracle