By Mark Gurry
I did not realize that this pocket reference was once nonetheless in its first printing, from January of 2002. As such lots of the content material is now out of date. in particular the writer devotes loads of house to evaluating the Rule-Based and Cost-Based Optimizers, and issues out the transparent superiority of the latter. This used to be significant information whilst Oracle 9i was once approximately to be published, no longer lots now.
As to the remaining, there are 22 pages (out of purely 102) enumerating the various tricks you'll be able to practice to SQL. there isn't a lot right here that won't already on hand from Oracle documentation at once.
Read Online or Download Oracle SQL tuning: pocket reference PDF
Similar oracle books
This e-book lias been written for the next audiences:■ Management-You could have bought Oracle9i for purposes except Java improvement in the database. in spite of the fact that, in an effort to be aware of extra approximately Oracle9i Java gains, see "Overview of Oracle9i Java Documentation" on web page 1-23 for a administration viewpoint.
There are few books out that care for Oracle textual content and XSQL. making use of the methodologies, practices, and so forth. i discovered little need to look for an additional reference.
Oracle functionality Survival advisor a scientific method of Database Optimization the short, entire, start-to-finish consultant to optimizing Oracle functionality Oracle functionality Survival advisor deals a established, systematic, start-to-finish method for optimizing Oracle functionality as successfully as attainable.
This self-study examination instruction consultant for the Oracle Database 10g Database Administrator OCP certification examination comprises every thing you must attempt your self and go the examination. All examination subject matters are lined and insider secrets and techniques, entire reasons of all Oracle Database 10g Database Administrator OCP matters, try out methods and assistance, various hugely life like pattern questions, and workouts designed to reinforce figuring out of Oracle Database 10g Database Administrator OCP innovations and get ready you for examination good fortune at the first test are supplied.
- Oracle Application Server 10g administration handbook
- ORACLE BUSINESS INTELLIGENCE AND ESSBASE SOLUTIONS GUIDE
- Sams Teach Yourself PL SQL in 21 Days (2nd Edition)
- Oracle Database 11g, A Beginner's Guide
Extra resources for Oracle SQL tuning: pocket reference
This is because scanning the index requires Oracle to scan past the logically deleted Victorian (`VIC') entries. To avoid the types of performance problems I've just demonstrated, my recommendation is to rebuild a table, and its indexes, whenever the table has undergone many deletes. If index columns are frequently updated, you should also re-build the indexes, because an update forces a logical delete in the index followed by an insert of the new, updated entry. Some sites go as far as rebuilding indexes nightly when they have a lot of logical delete activity.
The WHERE clause forces the use of the index, which results in rows being returned in sorted order. One advantage of eliminating the sort in an online application is that the first screenful of rows can be returned quickly. SELECT acc_name, acc_surname FROM account WHERE acc_name > chr(1) In a statement like this, there is no need to have the ORDER BY clause. If the ORDER BY clause was specified, and the user put in a BLANK for his selection and pressed the GO button, every single row in the table would need to be sorted before a single row could be returned.
UPDATE /*+ hint text */ . . SELECT /*+ RULE */ . . FROM emp WHERE emp_status = 'PART-TIME' UNION SELECT /*+ ALL_ROWS */ . . 2 Using Hints in Views Oracle discourages the usage of hints in views because views can be used in different contexts from one usage to the next.