Oracle SQL Tuning Pocket Reference



Bookstore > Books > Oracle SQL Tuning Pocket Reference

Price$6.76 - $9.96
Rating
AuthorMark Gurry
PublisherO'Reilly Media
Published2002
Pages112
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-100596002688
ISBN-139780596002688
EBook Hardcover Paperback

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. Mark provides a number of handy SQL tuning tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.


  1. (2 books)


4 5 50

Similar Books


Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

by Steven Feuerstein, Bill Pribyl, Chip Dawes

Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.Whether you're a developer or database administrator, when you need answers quickly, the Oracle PL/SQL La...

Price:  $12.49  |  Publisher:  O'Reilly Media  |  Release:  2015

Oracle DBA Checklists Pocket Reference

Oracle DBA Checklists Pocket Reference

by Quest Software

Oracle database administration is a complex and stressful job. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step-by-step "cookbook" approach to presenting DBA quick-reference material. The Oracle DBA Checklists...

Price:  $3.80  |  Publisher:  O'Reilly Media  |  Release:  2009

Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with Oracle SQLTXPLAIN

by Stelios Charalambides

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tu...

Price:  $33.95  |  Publisher:  Apress  |  Release:  2013

grep Pocket Reference

grep Pocket Reference

by John Bambenek, Agnieszka Klus

grep Pocket Reference is the first guide devoted to grep, the powerful Unix content-location utility. This handy book is ideal for system administrators, security professionals, developers, and others who want to learn more about grep and take new approaches with it - for everything from mail filtering and system log management to malware...

Price:  $8.99  |  Publisher:  O'Reilly Media  |  Release:  2009

vi and Vim Editors Pocket Reference, 2nd Edition

vi and Vim Editors Pocket Reference, 2nd Edition

by Arnold Robbins

Many Unix, Linux, and Mac OS X geeks enjoy using the powerful, platform-agnostic text editors vi and Vim, but there are far too many commands for anyone to remember. Author Arnold Robbins has chosen the most valuable commands for vi, Vim, and vi's main clones-vile, elvis, and nvi-and packed them into this easy-to-browse pocket refere...

Price:  $11.20  |  Publisher:  O'Reilly Media  |  Release:  2011

Canvas Pocket Reference

Canvas Pocket Reference

by David Flanagan

The Canvas element is a revolutionary feature of HTML5 that enables powerful graphics for rich Internet applications, and this pocket reference provides the essentials you need to put this element to work. If you have working knowledge of JavaScript, this book will help you create detailed, interactive, and animated graphics - from charts...

Price:  $6.57  |  Publisher:  O'Reilly Media  |  Release:  2010

GNU Emacs Pocket Reference

GNU Emacs Pocket Reference

by Debra Cameron

GNU Emacs is the most popular and widespread of the Emacs family of editors. It is also the most powerful and flexible. Unlike all other text editors, GNU Emacs is a complete working environment -- you can stay within Emacs all day without leaving. The GNU Emacs Pocket Reference is a companion volume to O'Reilly's Learning GNU E...

Price:  $3.74  |  Publisher:  O'Reilly Media  |  Release:  1998

Perl/Tk Pocket Reference

Perl/Tk Pocket Reference

by Stephen Lidie

The Perl/Tk Pocket Reference is a companion volume to Learning Perl/Tk, an O'Reilly Animal Guide. Learning Perl/Tk is a tutorial for Perl/Tk, the extension to Perl for creating graphical user interfaces. With Tk, Perl programs can be window-based rather than command-line based, with buttons, entry fields, listboxes, menus, scrollbars...

Price:  $4.00  |  Publisher:  O'Reilly Media  |  Release:  1998