Oracle PL/SQL Tuning: Oracle PL/SQL
Product Description
Oracle PL/SQL Tuning: Oracle PL/SQL
<b>Oracle PL/SQL is a very powerful language used extensively in the real world. This book will help you extract the best performance out of your PL/SQL code using tips and techniques. The examples are real and the performance gains are real too. The techniques like using bind variables, use of caching of result cache, reduce the redundant functions calls, etc will help you optimize your code and take your PL/SQL skill to the next level.</b> <br /> <br /><b>Chapter 1: Tune Functions</b> <br /> Reduce Function Calls <br /> Use Result Cache Function <br /> Tune Function Queries <br /> Create Function Index <br /> Use Oracle Supplied Function <br /><b>Chapter 2: Tune Procedures </b> <br /> Use Bind Variables <br /> Dynamic Query with Bind Variables <br /> Deleting the Data <br /> Delete Duplicate Data <br /> Delete using ALTER TABLE TRUNCATE PARTITION <br /> Cache Sequence <br /> Bulk Insert using Direct Path <br /> Table and Row Locking and Performance <br /> <br /><b>Chapter 3 €“ Tune Loops</b> <br /> Commit in Loop <br /> Use BULK COLLECT and FORALL <br /> Don€t Forget EXIT Condition <br /> Avoid Loop When Possible <br /><b>Chapter 4: Tune IF Statements</b> <br /> Short Circuit Evaluation <br /> CASE Statement <br /><b>Chapter 5: Tune Triggers</b> <br /> Avoid Triggers When Possible <br /><b>Chapter 6: Other Miscellaneous Things</b> <br /> Run in parallel using DBMS_PARALLEL_EXECUTE package <br /> DBMS_PROFILER package <br /> PL/SQL Native Compilation <br /> Oracle PL/SQL Manual <br /> <br />This book is a culmination of author's 20 years of experience of using Oracle SQL and PL/SQL.
