> Harrison's book is 'ok'. Doesn't teach you how to tune and has a > huge and pretty pathetic error in it. It says you can improve > performance of some updates by using a cursor and updating inside > the cursor. Its actually takes about twice as long or worse. Clearly > he never tested that statement. To be fair the 8i version of > Fuersteins pl/sql book has the same error(never read the 9i one). Perhaps an example would help. I don't have the book handy to check, but there are cases where updating inside is cursor is very fast. Ever used "where current of"? > For overall tuning the book to get is 'Optimizing Oracle > Performance' by Carrie Milsap. I also recommend going to www.hotsos. > com and reading his articles. "Cary" is of the male gender. Maybe that will help. > For general Oracle get Tom Kyte's 'Expert one on One'. His tuning > book is 'ok', but the other two I mentioned are better. OK? You either didn't read it, or didn't learn anything from it. Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------