Fee Download Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade
Finding the best Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade publication as the appropriate requirement is kind of lucks to have. To begin your day or to finish your day during the night, this Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade will certainly be proper sufficient. You can simply look for the floor tile below as well as you will get the book Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade referred. It will not trouble you to cut your useful time to go with purchasing publication in store. This way, you will certainly additionally spend money to pay for transport and also various other time spent.
Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade
Fee Download Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities, by Kevin Meade
Is Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade publication your favourite reading? Is fictions? Just how's regarding record? Or is the very best seller unique your choice to satisfy your spare time? Or perhaps the politic or religious publications are you searching for currently? Below we go we offer Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade book collections that you need. Great deals of numbers of publications from many areas are supplied. From fictions to science as well as spiritual can be searched as well as found out here. You could not stress not to discover your referred publication to check out. This Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade is among them.
Here, we have countless publication Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade and collections to check out. We also serve variant types and sort of the publications to search. The enjoyable e-book, fiction, history, unique, science, and also various other sorts of publications are readily available below. As this Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade, it ends up being one of the recommended book Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade collections that we have. This is why you remain in the right website to view the fantastic e-books to possess.
It won't take more time to purchase this Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade It will not take even more cash to print this e-book Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade Nowadays, individuals have been so clever to make use of the technology. Why do not you utilize your device or various other device to save this downloaded soft data book Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade In this manner will certainly let you to constantly be come with by this e-book Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade Certainly, it will certainly be the best buddy if you review this publication Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade up until completed.
Be the first to get this publication now and obtain all reasons you should read this Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade Guide Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade is not only for your tasks or necessity in your life. E-books will certainly consistently be a good pal in every time you check out. Now, allow the others understand about this page. You could take the advantages and share it also for your good friends and also people around you. By by doing this, you can really get the meaning of this publication Oracle SQL Performance Tuning And Optimization: It's All About The Cardinalities, By Kevin Meade profitably. Exactly what do you think about our idea right here?
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
- 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
- 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
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
No comments:
Post a Comment