PDF Download Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade
By downloading and install the online Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade book here, you will get some benefits not to go for guide store. Just hook up to the web as well as begin to download the page link we discuss. Currently, your Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade is ready to take pleasure in reading. This is your time and also your tranquility to get all that you really want from this publication Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade
PDF Download Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade
Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade. Let's read! We will certainly frequently discover this sentence anywhere. When still being a childrens, mommy made use of to purchase us to constantly check out, so did the educator. Some books Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade are completely checked out in a week as well as we require the commitment to assist reading Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade Exactly what around now? Do you still enjoy reading? Is checking out simply for you that have commitment? Not! We below provide you a brand-new book entitled Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade to check out.
As understood, many individuals claim that books are the vinyl windows for the globe. It doesn't suggest that buying book Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade will certainly imply that you could get this globe. Merely for joke! Reading an e-book Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade will certainly opened up a person to think better, to maintain smile, to captivate themselves, and to encourage the expertise. Every book additionally has their particular to affect the visitor. Have you recognized why you read this Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade for?
Well, still perplexed of how you can obtain this publication Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade below without going outside? Simply attach your computer system or kitchen appliance to the website and begin downloading and install Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade Where? This page will show you the link page to download Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade You never ever fret, your preferred book will be sooner your own now. It will certainly be a lot easier to take pleasure in reviewing Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade by online or obtaining the soft file on your device. It will certainly no matter who you are as well as just what you are. This publication Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade is written for public as well as you are just one of them that can appreciate reading of this publication Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade
Spending the leisure by reviewing Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade can supply such great experience even you are only sitting on your chair in the workplace or in your bed. It will certainly not curse your time. This Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade will direct you to have even more priceless time while taking rest. It is very delightful when at the noon, with a cup of coffee or tea and also an e-book Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade in your device or computer screen. By taking pleasure in the views around, here you could begin checking out.
Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database. Not a list of one-off tricks or tips, nor a glossing over of topics; this book offers an in-depth process covering discovery, analysis, and problem resolution. Learn the science behind SQL Tuning.
- Learn and apply the FILTERED ROWS PERCENTAGE Cardinality based method of tuning
- Determine a query's Driving Table and Join Order
- Construct Query Diagrams, Data Models, and Join Trees
- Build and use Count / Filter / and Reconstruction Queries
- Identify Waste in a Query Execution Plan
- Zero in on Cardinality Divergence using Estimated vs. Actuals
- Use the ACCESS / FILTER / COVERAGE strategy to build indexes for Problem Queries
- Exploit THE 2% RULE in analyzing Access method and Join method
- Classify queries as Precision Style or Warehouse Style
- Understand Hash Join mechanics and make Hash Joins go faster
- Make HINTS work as Detection Tools rather than clubs
- Avoid early Database Design flaws
- Manage Statistics and deal with common Statistics problems
- (NDV, Uniform Distribution, Independence, Dynamic Sampling)
- (Staleness, Skew, Dependence, Defaulting, Out-Of-Bounds, Transiency, Bloat)
- Perfect your Question Based Analysis Technique
- and more
Included are: a special chapter for EXADATA, a LAB which demonstrates the cardinality based process of SQL Tuning, and twenty three magical SQL scripts that make the process of SQL tuning easy to do. Learn the skill of SQL Tuning as taught by an expert who does it for a living, and become the go-to specialist in your company.
- Chapter 1: DRIVING TABLE and JOIN ORDER
- Chapter 2: Ways to Use a Query Execution Plan
- Chapter 3: The Best Indexes for a Query
- Chapter 4: JOINS
- Chapter 5: HINTS
- Chapter 6: BASICS
- Chapter 7: ROW COUNTS and RUN TIMES
- Chapter 8: EXADATA
- LAB: Reverse Engineering the QEP
- Appendix: Know Your Scripts
- Scripts for analyzing queries and plans
- Scripts for examining an active database
- Scripts for looking at metadata
- showplan
- showplanshort
- showplanconstraints
- showplancountqueries
- showplandatamodel
- showplandrivingtable
- showplanfilterqueries
- showplanfrpspreadsheetcode
- showplanindexes
- showplannumrows
- showplanquerydiagram
- showplantables
- showplantablesunique
- loadplanfromcache
- loadplanfromhist
- showtopcpu
- showowner
- showindexes
- showconstraints
- showcolstats
- showhistograms
- showallscanrates
- showallworkareas
It's all about the Cardinalities
- Sales Rank: #71197 in Books
- Published on: 2014-09-16
- Original language: English
- Number of items: 1
- Dimensions: 9.25" h x 1.28" w x 7.50" l, 2.09 pounds
- Binding: Paperback
- 568 pages
Most helpful customer reviews
9 of 10 people found the following review helpful.
Excellent tuning book
By Mladen Gogala
I am a long time DBA, turned consultant. I have more than 25 years of tuning experience and have been applying many of Kevin's advices for years.
This is an excellent tuning book, presenting the formalized tuning methodology for tuning queries against Oracle RDBMS. Not only is it full of seemingly apparent but frequently forgotten ideas like "learn your query", it also covers advanced topics like dynamic sampling and cardinality feedback. I like the book a lot. Why did I decide to give it only 4 stars out of possible 5? For two reasons: the examples are mainly written using the Oracle SQL dialect, with very few written using ANSI SQL. ANSI SQL is the dialect most frequently generated by the now ubiquitous application generator. The second reason for deciding to rate the book by only 4 stars is a huge emphasis on Exadata. I do not meet Exadata that frequently and I do not consider that part relevant for a general tuning book.
Those criteria are, of course, my personal rating criteria. Once again, I consider those shortcomings minor and want to stress that I have thoroughly enjoyed myself reading the book.
5 of 5 people found the following review helpful.
An excellent book on oracle sql tuning
By Ram
This is a great book on SQL tuning for Oracle. I have several years of experience yet I still have lot to learn, esp in SQL tuning. There are several books in the market which are a rehash of the manuals or just skim over this topic or too hard to follow. This book takes the basic topics related to SQL tuning and presents them in a logical and coherent manner. I learned a lot about reading the sql statements and the plans, tuning the SQLs, look for hot spots and apply a standard approach to tuning. The book lays the foundation to understand SQL, takes you through a series of journeys into the SQL world which is helpful to understand SQL tuning.
Each chapter deals with specific topic. The first chapter provides a good set of basic building blocks on how to tune queries. Great ideas with the FRP method approach. After reading the first chapter I tuned a query with several underlying tables by selecting a 'driving table'.
The second chapter explains cardinalities and why cardinalities are important and how the plans could go for a toss if cardinalities are off. I have read about the cardinalities in several other places on the internet, but the chapter explains the whole thing from the basics. A must read for any tuner. Chapter 3 elaborates how to choose indexes and deals with ACCESS, FILTER and post table filtering predicates.
The fourth chapter is on joins. This is the best chapter of the book in my view. The chapter deals with the most commonly used join methods such as nested loops, sort merge, etc and goes on to explain in detail the mechanisms involved under the hood. It also talks about when each case would be a best fit and its limitations and the most common problems each join method faces. The explanation of optimal, single pass and multi pass joins is just superb.
The fifth chapter deals with hints and says why the author is not totally against it or for it and talks about cases where certain handful of hints could be useful. The hints it talks about are what you have likely seen before, but the chapter explains why they are important and when they can be used. I have seen other works that deal about pretty much every hint in the manual without good explanation and why they should or should not be used, but this chapter focuses on the important hints and how and when to use them to your advantage. Chapter 6 called 'Basics'is a must read for people new and experienced alike. This tells you the most common mistakes people keep making and why you need to avoid them. I have a feeling when the second edition comes out this chapter will expand (and it has to) and probably get pushed to the front.
Chapter 8 is an introduction to exadata.
There are some places where the book can make some improvements, but nothing is a show stopper for me. The indexes at the end of the book can be more inclusive of the contents in the book. I would also like to see more SQL tuning examples possibly from various environments - this book already has several examples, but I would like to see examples from various types of systems like certain packaged applications, etc.
Conclusion:
This book is a great start if you are beginning with oracle or good booster if you are already an oracle practitioner. I have read several topics discussed in this book in bits and pieces before from various sources, but the book gives a logical structure in taking you through various topics and lays a good foundation for moving from the 'beginner' level to 'intermediate' level in understanding and tuning SQL. I will keep the book with me for a long time as reference. Most of the information in the chapters apply to almost all versions of oracle since they deal with the core basics of tuning, so do not think you should not buy this book if you are reading this 10 years from today.
4 of 4 people found the following review helpful.
An excellent SQL tuning methodology
By John Watson
This book is the best book on SQL tuning that I have ever read. I do not say that because I was involved in the technical edit (I did one chapter) but because it is true. The author goes through what one might call the basics of tuning SQL, but that is not "basic" in the sense of "elementary": it is "basic" in the sense that these are things you must get right before doing anything else, or you will never get anywhere. Do not think that this book is for beginners. You need to know your way around SQL and DB admin already, and then it will teach you a lot.
For me, the highlight is the exposition of what I see as the three most critical decisions that the optimizer must make: join order, join method, and access method. This details why these decisions are so critical, how the optimizer makes them, why it sometimes makes the wrong decision, and how to prevent these errors. There is a very nice methodology (the "filtered rows percentage" method) presented for this..
The book does not go into more esoteric subjects, such as tuning non-mergeable views or using non-heap table structures, but it covers everything that you need to fix nine out of ten of your fixable SQL tuning problems. Next time you are looking for an enjoyable way to spend a Friday afternoon at the end of a hard week, find some horrendous query with an execution plan that takes a kilometer of continuous stationery to print, and use the techniques in this book to tune it from ten hours down to ten seconds. That's what you will get from this book: a method for doing just that.
--
John Watson
Oracle Certified Master DBA
http://skillbuilders.com
See all 25 customer reviews...
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade PDF
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade EPub
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade Doc
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade iBooks
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade rtf
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade Mobipocket
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade Kindle
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade PDF
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade PDF
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade PDF
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade PDF
