Close
Enter your search into one or more of the boxes below:
You can refine your search by selecting from any of the options below:
Search
Expert Oracle SQL: Optimization, Deployment, and Statistics

Expert Oracle SQL: Optimization, Deployment, and Statistics (Paperback)

£38.50
Usually despatched in 7-10 days.
Order now for Free delivery in the UK.
More on delivery...

Synopsis

Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. You'll learn not only to improve performance when it is too slow, but also to stabilize performance when it is too variable. You'll learn about system statistics and how the Cost-Based Optimizer uses them to determine a suitable execution plan for a given statement. That knowledge provides the foundation from which to identify the root cause, and to stabilize and improve performance. Next after identifying a problem and the underlying root cause is to put in place a solution. Expert Oracle SQL: Optimization, Deployment, and Statistics explains how to apply various remedies such as changing the SQL statement, adding hints, changing the physical design, and more, and how they can be brought to bear on fixing a problem once and for all. Rolling a change out smoothly is an important topic when dealing with tuning and optimization. Expert Oracle SQL: Optimization, Deployment, and Statistics does not let you down in this critical area. The book contains two chapters of good information from an experienced professional on how to safely deploy changes into production so that your systems remaining running and available throughout the deployment process. Describes a systematic approach to tuning Oracle SQL Explains how things are supposed to work, what can go wrong, and how to fix it Takes you through the steps needed to stabilize performance in your production systems

Computing & ITDatabasesDatabase softwareOracle Publisher: Springer-Verlag Berlin and Heidelberg GmbH & Co. KG Publication Date: 24/06/2014 ISBN-13: 9781430259770  Details: Type: Paperback Format: Books
Availability: Usually despatched in 7-10 days. Login for Quick Checkout Add to Basket

Tony Hasler spends most workdays tuning database queries for financial institutions in the City of London from his office in Fife, occasionally looking over the Firth of Forth towards Edinburgh castle. Tony spent the first half of his 30 years in IT developing software, during some of which time he worked with the International Standards Organisation (ISO) on interoperability standards in transaction processing. He also filed a patent on optimisations in two-phase-commit logging mechanisms. For most of the last 15 years Tony has been solving performance issues for major financial institutions throughout Europe. He is a regular speaker at UK Oracle User Group conferences.

More books by Tony Hasler

Leave Review

Delivery

Delivery Options

All delivery times quoted are the average, and cannot be guaranteed. These should be added to the availability message time, to determine when the goods will arrive. During checkout we will give you a cumulative estimated date for delivery.

Location 1st Book Each additional book Average Delivery Time
UK Standard Delivery FREE FREE 3-5 Days
UK First Class £4.50 £1.00 1-2 Days
UK Courier £7.00 £1.00 1-2 Days
Western Europe** Courier £17.00 £3.00 2-3 Days
Western Europe** Airmail £5.00 £1.50 4-14 Days
USA / Canada Courier £20.00 £3.00 2-4 Days
USA / Canada Airmail £7.00 £3.00 4-14 Days
Rest of World Courier £22.50 £3.00 3-6 Days
Rest of World Airmail £8.00 £3.00 7-21 Days

** Includes Austria, Belgium, Denmark, France, Germany, Greece, Iceland, Irish Republic, Italy, Luxembourg, Netherlands, Portugal, Spain, Sweden and Switzerland.

Delivery Help & FAQs

Returns Information

If you are not completely satisfied with your purchase*, you may return it to us in its original condition with in 30 days of receiving your delivery or collection notification email for a refund. Except for damaged items or delivery issues the cost of return postage is borne by the buyer. Your statutory rights are not affected.

* For Exclusions and terms on damaged or delivery issues see Returns Help & FAQs

You might also like

Oracle Business Intelligence with...
(Paperback)
Rosendo Abellera; Lakshman Bulusu
 
 
£31.99
 
Oracle Incident Response and...
(Paperback)
Pete Finnigan
 
 
£15.99
 
Oracle Application Express by Design:...
(Paperback)
Patrick Cimolini
 
£29.99
£12.50
58%
Latest Blog
#FoylesFive: Polish Fiction
22/02/2018

Gary from our Fiction Department delights us with a few of his favourite Polish novels.

Get More!
22/02/2018

We've extended the range of available lines on our website to close to one million items across more than thirty product categories! OK, that actually sounds quite dull. But what it means is you've got more books to choose from, more subject areas, more titles available on our website than ever before — more more more! To celebrate, we're giving you 15% off everything* online when you use the code GETMORE at checkout anytime between Thursday 22nd February and Thursday 1st March 2018.

Folklore of the Yorkshire Moors
10/02/2018

View all Blog Entries
Twitter
Show/Hide Tweets
© W&G Foyle Ltd