Oracle PL/SQL Tuning

Condition - Very Good
The item shows wear from consistent use, but it remains in good condition and functions properly. Item may arrive with damaged packaging or be repackaged. It may be marked, have identifying markings on it, or have minor cosmetic damage. It may also be missing some parts/accessories or bundled items.

Oracle PL/SQL Tuning

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.

Chapter 1: Tune Functions
Reduce Function Calls
Use Result Cache Function
Tune Function Queries
Create Function Index
Use Oracle Supplied Function
Chapter 2: Tune Procedures
Use Bind Variables
Dynamic Query with Bind Variables
Deleting the Data
Delete Duplicate Data
Delete using ALTER TABLE TRUNCATE PARTITION
Cache Sequence
Bulk Insert using Direct Path
Table and Row Locking and Performance

Chapter 3 â€“ Tune Loops
Commit in Loop
Use BULK COLLECT and FORALL
Donâ€™t Forget EXIT Condition
Avoid Loop When Possible
Chapter 4: Tune IF Statements
Short Circuit Evaluation
CASE Statement
Chapter 5: Tune Triggers
Avoid Triggers When Possible
Chapter 6: Other Miscellaneous Things
Run in parallel using DBMS_PARALLEL_EXECUTE package
DBMS_PROFILER package
PL/SQL Native Compilation
Oracle PL/SQL Manual

This book is a culmination of author's 20 years of experience of using Oracle SQL and PL/SQL.

Country	USA
Author	Bhavesh Tailor
Binding	Kindle Edition
Edition	1.1
Format	Kindle eBook
IsAdultProduct
Label	Bhavesh Tailor
Manufacturer	Bhavesh Tailor
NumberOfPages	125
PublicationDate	2014-04-15
Publisher	Bhavesh Tailor
ReleaseDate	2014-04-15
Studio	Bhavesh Tailor

You might also like...