{"product_id":"oracle-high-performance-sql-tuning-paperback","title":"Oracle High-Performance SQL Tuning - Paperback","description":"\u003cp\u003eby \u003cb\u003eDonald Burleson\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePublisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.\u003c\/b\u003e\u003cbr\u003e\u003cb\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003eFrom the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003eThis expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.\u003cbr\u003e\u003c\/p\u003e\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eImprove Database Performance by Tuning SQL Statements\u003c\/p\u003e \u003cp\u003eTune all types of SQL statements--from a simple SELECT statement to a complex non-correlated subquery--using tips and techniques from SQL expert Don Burleson. Officially authorized by Oracle Corporation, this in-depth resource explains how to take any SQL statement, view the internal execution plan, and change the execution plan to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eUnderstand how SQL tuning fits into the overall Oracle tuning model \u003c\/li\u003e\n\u003cli\u003eImprove Oracle SQL functionality using extensions such as in-line views and BIFs \u003c\/li\u003e\n\u003cli\u003eIdentify and report on SQL in the library cache \u003c\/li\u003e\n\u003cli\u003eTune SQL table access, full-table scans, and parallel query \u003c\/li\u003e\n\u003cli\u003eRun TKPROF to get a SQL trace report \u003c\/li\u003e\n\u003cli\u003eChange the execution plans for Oracle SQL statements using Oracle hints \u003c\/li\u003e\n\u003cli\u003eUse the Oracle8\u003ci\u003ei\u003c\/i\u003e optimizer plan stability, cost-based optimizer, and rule-based optimizer \u003c\/li\u003e\n\u003cli\u003eTune SQL DML statements, SQL subqueries, and data warehouse SQL \u003c\/li\u003e\n\u003cli\u003eTune SQL with temporary tables and indexes \u003c\/li\u003e\n\u003cli\u003eDiagnose and optimize system performance using STATSPACK \u003c\/li\u003e\n\u003c\/ul\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 656\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.4 x 9.2 x 7.5 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e August 17, 2001\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42694967328831,"sku":"9780072190588","price":77.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/51a3121b680c390734c8a0be119a72fb.webp?v=1765002416","url":"https:\/\/dhl-adrianne.myshopify.com\/products\/oracle-high-performance-sql-tuning-paperback","provider":"BBB","version":"1.0","type":"link"}