Oracle SQL Tuning Pocket Reference, Paperback Book

Oracle SQL Tuning Pocket Reference Paperback

Share

Description

In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers.

Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients.

Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you.

He also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers.

In addition to the specific problem/solution scenarios for the optimizers, the book provides a number of SQL tuning tips.

It discusses the various optimizer hints, telling you when they can be used to good effect.

Finally, it discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify..

Information

  • Format: Paperback
  • Pages: 100 pages, black & white illustrations
  • Publisher: O'Reilly Media, Inc, USA
  • Publication Date:
  • Category: Database programming
  • ISBN: 9780596002688

£7.99

£6.29

Free delivery within the UK
Free
Standard Delivery
Within the UK

Also by Mark Gurry   |  View all

£63.99

£35.59

Available with free
standard delivery

£6.60

£5.28

Available for
immediate download

£54.60

£43.68

Available for
immediate download

£6.60

£5.28

Available for
immediate download