Skip to Main Content
Oracle PL/SQL Performance Tuning Tips & Techniques
book

Oracle PL/SQL Performance Tuning Tips & Techniques

by Michael Rosenblum, Paul Dorsey
August 2014
Intermediate to advanced content levelIntermediate to advanced
336 pages
7h 58m
English
McGraw Hill Computing
Content preview from Oracle PL/SQL Performance Tuning Tips & Techniques

Image

CHAPTER4Expanding the SQL Horizons

The following good-old database half-wisdom/half-joke, often attributed to Tom Kyte, is still as valid as ever:

        1. If you have something to do in the database, do it in SQL.

        2. If you cannot do it in SQL, do it in PL/SQL.

        3. If you cannot do it in either SQL or PL/SQL, do it in Java.

        4. If you cannot do it in Java, do it in C.

        5. If you cannot do it in C, are you sure that it needs to be done?

The reality is a bit more complicated because there are a lot of dimensions involved when comparing different approaches, such as performance, maintainability, available expertise, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein

Publisher Resources

ISBN: 9780071824828