-
PL/SQL performance tuning
Hi
Can anyone let me know how to do PL/SQL perfromance tuning.I am new to this concept.Pls let me know.
Thanks in advance
-
The best way is to go through the *design* process with performance being a major consideration. Yea, that's the easy answer, but it's true. A good book on how to write PL/SQL the right way will always take performance into consideration. Here's a suggestion... there are others... browse em at the bookstore.
http://www.amazon.com/exec/obidos/AS...071487-0060838
The deal is, the SQL that appears in PL/SQL should be tuned on a statement per statement basis, as any SQL statement should be. But, PL/SQL being *procedural* introduces another aspect, and that is what the books will go into. When to use a cursor, when [not] to commit, how to combine embedded loops into a single statement, bind variables (a BIG performance issue), dynamic SQL (different ways of doing it), among others things.
Tom Best
-
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|