A guide to using Oracle's parallel query facility for large volume queries focusing on SQL and PL/SQL. Harrison, an Oracle developer and consultant, overviews SQL processing and introduces guidelines to improve applications, including execution plans, work with joins, nulls and ranges search, index building, hierarchical queries, table scans, GROUP BY, updates, and distributed SQL. The accompanying CD-ROM features a set of tools for detecting and correcting SQL bottlenecks. Annotation c. by Book News, Inc., Portland, Or.
GUY HARRISON has worked with Oracle databases for over 10 years as a developer, database administrator, and consultant. He has conducted performance reviews for some of Australia's biggest Oracle applications. He has also conducted many Oracle SQL tuning seminars and has authored several articles for the Oracle Technical Journal.