SQL and PL/SQL are deceptively simple, user-friendly languages, which is great for productivity, but also makes it relatively easy to write bad, non-scalable code. Certain features, in particular, seem to sound an irresistible siren call into a world of Oracle applications that perform poorly and yield unpredictable results.
In this webinar, Tom Kyte, a Senior Technical Architect at Oracle Corporation, and the man behind asktom.oracle.com, takes a look at a few of the worst offenders:
- Triggers - much trickery is possible via triggers, and much of it causes pain, confusion and unexpected side effects
- Indexes, NULLs and cardinality - misinformation abounds with regard to the effect of NULLs on cardinality estimates, and the impact of NULLs on index use
- Implicit conversions - strings to numbers, strings to dates, raw to string… probably #2 on the list of ‘bugs I see time and time (and time) again’
With Tom’s typically example-driven approach, you’ll see first-hand evidence of the damage caused when fundamental features are misused, misunderstood and implemented badly.
A live Q+A session with Tom follows the presentation.