Home
Search results “Oracle cost cardinality”
What is Cardinality and High Cardinality and Low Cardinality in Oracle
 
05:47
What is Cardinality and High Cardinality and Low Cardinality in Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1660 TechLake
Oracle Cost Based Optimizer Basics
 
02:12:35
When it comes to writing efficient queries there are a few key concepts that need to be understood. One of them is the Oracle Cost-Based Optimizer (CBO). Although it's called a cost-based optimizer it's actually not the cost we need to focus on primarily to understand why the optimizer makes certain decisions. In this webinar, you will learn the basics of the CBO, see why it is crucial that the optimizer's picture of the data fits reality, why cardinality and selectivity estimates matter so muc
Views: 59273 Redgate Videos
Oracle SQL Tuning - How to Read Execution Plans (Explain Plan)
 
13:39
In this free tutorial you will learn how to generate and read (interpret) an execution plan in Oracle Databases. See more FREE Oracle Tuning tutorials at http://skillbuilders.com/free-oracle-tutorials. Understanding what the Oracle Database does with your SQL is essential to tuning - and the execution plan is the key. Oracle Certified Master DBA John Watson will provide a brief introduction (4 minutes) - which includes John's tuning methodology, then demonstrate EXPLAIN PLAN, SQL*Plus AUTOTRACE and DBMS_XPLAN.DISPLAY_CURSOR. In the tutorial, John will teach you: - How to read an execution plan - Find the 1st step in the plan - Decipher the order of the steps in the plan - That EXPLAIN PLAN can be very misleading Prerequisites: To get the most from this tutorial, you should: 1 Know how to code SQL 2 Be familiar with SQL*Plus 3 Know - in very general terms - what an execution plan is. 4 Have a basic understanding of the Library Cache (this is where Oracle Database stores parsed SQL statements) 5 Have a basic understanding of the Cost Based Optimizer (this is the part of the database that parses your SQL, creates an execution plan. Hopefully the correct - most efficient - plan).
Views: 69215 SkillBuilders
Oracle Optimizer Cost Calculation from explain plan
 
02:23
This presentation describes the method to understand how oracle calculate cost during explain plan generation
Views: 754 debasis maity
Oracle SQL Tuning Re-Optimizing Execution Plans with Cardinality Feedback
 
15:37
Cardinality feedback, introduced with Oracle Database 11g, has been significantly enhanced with 12c. Cardinality feedback allows the CBO to learn from a cardinality estimate mistake and re-optimize the execution plan. Learn more in this free SQL Tuning tutorial. See all free Oracle Database tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3277 SkillBuilders
07 07 Index Selectivity
 
07:56
ORACLE
Views: 496 oracle ocm
14  Index Cardinality
 
02:45
Views: 50 B's March
SQL Server Cardinality Estimation – Quick Notes – Part 1 (by Amit Bansal)
 
09:08
In this video you will learn how the SQL Optimizer uses Density information to compute default cardinality estimations Learn about Amit Bansal’s ultimate video course on SQL Server Performance Tuning: http://bit.ly/abvideocourse Stay Connected with Amit Bansal and subscribe to the exclusive list of his session attendees (conference and pre-cons), class participants & video viewers. You will get just one email in two weeks with good links to continue your learning. http://bit.ly/connectwithab Also, you can join ‘SQLMaestros Champs’ Telegram group and participate in SQL Server discussions. It’s a forum for SQL Server lovers - https://t.me/joinchat/AnAGwxBU1KXORoUR9jD_dw If you work on other technologies in MS Data + AI Stack, join this group: http://www.dataplatformgeeks.com/dpg-mobile/ Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ - http://www.twitter.com/SQLMaestros - https://www.facebook.com/SQLMaestros - Email us: [email protected] Data Platform Summit Asia's largest learning event on AI, Data & Advanced Analytics. https://www.dps10.com/ SQLMaestros Video Courses Amit Bansal’s popular SQL Performance Tuning course is now going live in video format. http://sqlmaestros.com/sql-server-videos-courses/ SQLMaestros Hands-On-Labs Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere. http://hols.SQLMaestros.com Email [email protected] SQLMaestros Learning Kits The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. https://sqlmaestros.com/sql-server-courseware/ SQL Server Health Check If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. https://sqlmaestros.com/sql-server-health-check/ Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 Our Telegram group on mobile http://www.dataplatformgeeks.com/dpg-mobile/ DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development If you wish to speak at DataPlatformGeeks events, fill out this form: http://www.dataplatformgeeks.com/call-speakers-dpg-events/ If you wish to become a Regional Mentor with DataPlatformGeeks, fill out this form: http://www.dataplatformgeeks.com/become-regional-mentor/ Watch all recorded DPG webinars here: www.youtube.com/SQLServerGeeks
Views: 3368 SQLMaestros
Oracle Star Transformation
 
12:57
Oracle Star Transformation
Views: 286 The Silent DBA
Oracle 12c Dynamic Sampling
 
08:26
Learn how to improve cardinality and performance of SQL statements with Oracle Database 12c Dynamic Sampling. For you Spinal Tap fans, you can now set it to "11".
Views: 1042 SkillBuilders
Statistics and Query Plans
 
01:12:00
If you want to tune queries, you have to look at query plans and you have to understand what they’re showing you. One thing people look for when tuning is “bad cardinality estimates”. If you’ve wondered what that means, and you want to understand how the optimizer uses statistics when creating a query plan, then join me for this session on statistics and query plans. We’ll set the stage with a review of what statistics are, then see how the optimizer uses them and where to find that “cardinality estimate” information in a plan. We’ll also cover the various ways statistics can be updated, explore what happens to plans when those updates occur, and ultimately you will see why understanding how it all works is critical when you’re troubleshooting performance issues. Expect lots of demos so you can truly understand what statistics are, how they're used, and why their management is so essential for good performance.
Views: 75 Sarah H
Oracle Database 12c: Adaptive Execution Plans with Tom Kyte
 
05:42
Tom Kyte introduces adaptive execution plans followed by a demo. "Adaptive Plans" in SQL Tuning Guide" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL221 "Controlling Adaptive Optimization" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL257 "Generating and Displaying SQL Execution Plans" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL271 "Keeping Your Database Secure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBSEG009
Views: 14600 OracleDBVision
SQL: Optimizer- RBO/CBO (Part-1)
 
05:39
In this Tutorial, you will know what is RBO and the disadvantages of it..
Views: 11587 radhikaravikumar
12c Adaptive Optimization - Kerry Osborne
 
01:08:29
One of the most interesting new features of the Oracle Database Optimizer is the ability to recognize its own mistakes and use execution statistics to automatically improve execution plans. Oracle calls this "Adaptive Optimization" and this talk will focus on how it works. More webinars at: http://www.red-gate.com/oracle-webinars
Views: 7267 Redgate Videos
Using Auto DOP, Part 1
 
03:42
This video is the first in a two-part presentation on how to use the Auto DOP feature of Oracle Database 11g, Release 2. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
ORACLE WORLD - Understanding Oracle Optimizer Statistics part-2nd
 
10:09
Hello friends in this video i'm just showing to you what is optimizer statistics into oracle,optimizer help to improve the performance of sql statements during execution period. #ORACLEWORLD #OptimizerStatistics Oracle database Unbeatable,Unbreakable Platform.
Views: 2454 Oracle World
Statistics histogram Cardinality In simple word.
 
03:11
The SQL Server query optimizer uses distribution statistics when creating a query plan. The statistics provide information about the distribution of column values across participating rows, helping the optimizer better estimate the number of rows, or cardinality, of the query results. Cardinality (SQL statements) In SQL (Structured Query Language), the term cardinality refers to the uniqueness of data values contained in a particular column (attribute) of a database table. The lower the cardinality, the more duplicated elements in a column
Views: 360 SqlIsEasy
Histograms Pre-12c and now
 
43:45
Anju Garg is an Oracle Ace Associate with over 12 years of experience in IT Industry in various roles. Since 2010, she has been involved in teaching and has trained more than a hundred DBAs from across the world in various core DBA technologies like RAC, Data guard, Performance Tuning, SQL statement tuning, Database Administration etc. She is a regular speaker at Sangam and OTNYathra.  She also writes articles for All Things Oracle. She is passionate about learning and has keen interest in RAC and Performance Tuning. She shares her knowledge via her technical blog at http://oracleinaction.com/ ABSTRACT--- To improve optimizer estimates in case of skewed data distribution , histograms can be created. Prior to 12c frequency and height balanced histograms could be created.  if no. of buckets >= NDV, frequency histogram is created and the optimizer makes correct estimates. If no. of buckets < NDV, height balanced histogram is created and accuracy of optimizer estimates depends on whether a key value is an endpoint or not. The problem of optimizer misestimates in case of height balanced histograms is resolved to a large extent in Oracle Database 12c by introducing top-frequency and hybrid histograms which are created if no. of buckets < NDV. This webinar explores Pre as well post 12c histograms while highlighting the top-frequency and hybrid histograms introduced in Oracle Database 12c.
Oracle SQL Performance Tuning for Developers: Understand Explain Plans
 
01:42
Understanding Explain Plans is an excerpt from Oracle SQL Performance Tuning for Developers: http://www.informit.com/store/oracle-sql-performance-tuning-for-developers-livelessons-9780134117027 6+ Hours of Video Instruction The focus of Oracle SQL Performance Tuning for Developers LiveLessons is to illustrate coding techniques that ensure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements. Description In this video training, Dan Hotka starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This course then goes in-depth on understanding and controlling the Explain Plan, which is how and in what order Oracle retrieves data. The discussion includes considerable detail, with SQL examples, on how the optimizers--both rule-based and cost-based, but mostly cost-based--make their decisions. Students will work with a variety of SQL statements, reviewing Explain Plans and making changes to make these SQL statements perform better. Lectures include index design, using hints and coding style to control the Explain Plans, and how to use useful tools such as index monitoring, SQL Trace, and the PL/SQL profiler. This LiveLessons course takes a close look at indexes: how Oracle selects them, why they are sometimes not used, and how to tell if indexes are being used. This course includes Oracle10g, Oracle11g, and Oracle12c SQL tuning topics. Skill Level Intermediate Learn How To Read and understand Explain Plan content Review an Explain Plan and tell quickly if this is a good plan Understand a good index column candidate from a not-so-good candidate Quickly tell the likelihood if your SQL will use an existing index Use coding and a variety of Hints (directives) that can produce better performing SQL Execute and interpret SQL trace output Who Should Take This Course Oracle programmers Oracle database administrators who need additional training on SQL tuning Course Requirements Working knowledge of the SQL query language http://www.informit.com/store/oracle-sql-performance-tuning-for-developers-livelessons-9780134117027
Views: 3595 LiveLessons
Adaptive Dynamic Sampling ByChris Antognini
 
53:05
Topic: Adaptive Dynamic Sampling Speaker: Chris Antognini Videos thanks to Delphix! Thank you to our sponsors: Delphix, Pythian, and Gluent.
Views: 255 Oaktable
Oracle SQL Tuning - Equal SQL is not Always Equal
 
09:49
Learn how and why equivalent SQL statements can have a dramatic effect on performance. Certified Master J Watson demonstrates...See all our free Oracle Database tutorials at http://skillbuilders.com/free-oracle-tutorials. The Oracle Database cost-based optimizer (CBO) should recognize equivalent SQL statements and re-write them into the most efficient form. Well, nothing is perfect - not even Oracle Database. Sometimes the way you write your SQL can have a dramatic effect on performance. Presented by John Watson, Oracle Certified Master DBA. Some experience with SQL tuning is expected.
Views: 2070 SkillBuilders
Oracle Histograms Example
 
03:40
An excerpt from "Oracle SQL Tuning Video Tutorial" topic "Oracle Histograms in Oracle 12c" +91 991 2323 000 [email protected] Oracle SQL Tuning Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:125 Oracle DBA Performance Tuning https://dbvidya.talentlms.com/catalog/info/id:128 Dimensional Modeling Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:131 Erwin Tool Training Video Tutorial https://dbvidya.talentlms.com/catalog/info/id:130 Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/perform... http://www.dbvidya.com/course/dimensional-modeling/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-perform... Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-... Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-t... ER Data Modeling Course : http://www.dbvidya.com/course/er-mode... Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensi... Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 168 DbVidya
Oracle Database 12c Security - Oracle Virtual Private Database (VPD)
 
12:29
Learn how to use Oracle Virtual Private Database (VPD) to secure your data. See all lessons at http://skillbuilders.com/12c-TSDP-Tutorial First, Virtual Private Database. What is it? Answer: It's a declarative technique for enforcing security. Typically, it's based on user application context. That was the first limitation of 8i. Backed with 8i context were session-specific. The context variables were sort in the PGA. That means you simply couldn't use this in a web environment. However, global context, with use of 9i, Virtual Private Database became usable for web applications with connection pooling. But whether you're using it to client server or on a three tier environment, it's declarative technique rather than a programmatic technique. I can go behind the back of the application as a DBA and generate predicates to get appended to all SQLs. Select, insert, update, delete the end users. Issue the SQL and I will generate a predicate that filters the access. It's impossible to bypass. All users will have predicates appended to all their code. It doesn't matter whether they're using SQL Plus, Discoverer, Business Objects, Crystal Reports, eBusiness Suites, whatever they're using, I as DBA can filter their access to roles. The end result, different users see different data sets while running the same code and accessing the same tables, hence, the name Virtual Private Database. Different users will think they're seeing a totally different set of tables, but in fact it's one column database, one set of tables hosting a single application shared by all the users. The mechanism - you can apply VPD to tables, to views, to synonyms, and a declarative technique. Once the technique you write a function that generates the predicate, you associate the function with the table. From then on whenever the user issue SQL against that table the Cost-Based Optimizer rewrites the code. The Cost-Based Optimizer rewrites the user SQL to call the function to generate the predicate. The predicate is then appended to the SQL and it's the modified SQL that is parsed and executed. Let's see how this actually works. I'm working here by the way. This is just a perfectly normal 12.1 database. But what I'm going to demonstrate at this point will in fact work on 11g as well. I'm not going to be using any of the 12c enhancements to VPD for this little demonstration. I'll work in the scott schema. What do we have to do? We write a function to generate the predicate string. Create function. And I'll my function vpdf. The function must conform to a fixed specification. It must take two varchar arguments. One of the arguments is intended to be the schema to which the function will be applied. The other argument is the object within the schema to which the function will be applied. And it must return a varchar2, which is the generated predicate. Let's begin. Within this function you can do just about anything. There are some limitations. It's impossible for the function to query or update the table against which the VPD calls here is going to be applied or we violate the rules of purity that we come across so often with PL/SQL. But apart from that, it can do just about anything - including a number of dreadful side effects can be introduced by writing VPD functions. I'm going to do a very simple one on this one. I'll shall simple return immediately a predicate. What predicate? Ename, which is the ename column from this scott.emp table. Ename should equal sys_context. I'll go to the local context, my user end context, and just extract session user. We can see that John has tested this earlier today and therefore the object already was suggesting and he's just dropping it now and cleaning up the recreate. I hope you realize these really are live demonstrations. I'm not just running scripts. I've created a function. What's that function going to do? It's going to return this value here. Test it. Always test it and see what it's actually going to do. I'll select vpdf. I have to give it a couple of arguments. This one will do for now.
Views: 4768 SkillBuilders
Database and Its Applications Full Course | Introduction to Database Management System
 
04:13:25
Database and Its Applications Full Course | Introduction to Database Management System | Tutorial on SQL | E-R Model and Data Models Data Base Applications Unit Introduction: This unit introduces the term database, its types, and its advantages. It also focuses on basic structure and elements of database. At the end provide solid concept of entities. Unit No. 1 Database Foundation Introduction, Data and Information, Components, Advantages Data Association, Entities, Keys and Its Types, Attributes Data Associations, Data Structure Diagram Unit No. 2 E-R Model and Data Models Basic constructs (Symbols), Degree of Relationships, Cardinality, and Gerund Modeling Time Dependent Data, Super Types, Sub types Hierarchical, Network, Relational, Comparison of All Data Models Relations, Characteristics of relation, Converting E-R Model into Relation Unit. No. 3 Normalization (1NF, 2NF, 3NF) Unit No. 4 Data Base Design (Conceptual Design, Physical Design) Unit No. 5 SQL Introduction Introduction, Creating, Altering & Deleting Table Inserting, Updating, & Deleting Rows, Querying the Tables SQL Functions Arithmetic, Group (Average, Count, Max, Min, Sum) Date, Special Functions (In, Between, Like, Null) Unit No. 6 Introduction to Forms Form Components, Form Module, Blocks, Items, Objects, Object Navigator Properties Window, Layout Editor Unit No. 7 Basic Form Design Using Wizard for Form Design, Customizing a Form Defining Items Buttons, Check Boxes, Display items, List Items, Radio Groups, Text Items Creating LOV, Crating Master Detail Form Unit No. 8 Introduction to Reports Report Design Consideration Report Objects Basic Report Design Objectives Unit No. 1 Importance of Database Database Concepts Various Architectures of Database The Cost, Risk and Environment of Database Management System Difference between Data & Information The Concept of Entity, and Attributes Various Types of Attributes How Entities are recognized in an Entity Type How various types are associated with one another? Objectives of Unit No. 2 Architecture of entity relationship model Various types of relationship How the complexities of relationship are handled Effect of cardinality in relationship How multi value attributes are modeled How time dependent attributes are modeled Associative entity types are modeled Hierarchical data model Network data model Relational data model Why relational data model is in use? The basics of database design Recommended Books: Modern Data Base Management, by Jaffery A. Hoffer Oracle Developer 2000 by Michael Stowe Find us on Facebook: https://web.facebook.com/Computer-Education-for-All-1484033978567298 YouTube: https://www.youtube.com/channel/UCiV37YIYars6msmIQXopIeQ
Using Parallel and Cardinal Hint
 
07:44
This is a demo on using Parallel and Cardinal Hint to tune queries in ILM.
Views: 1357 Informatica Support
Oracle SQL Performance Tuning for Developers: Introduction
 
04:14
This video is an introduction to Oracle SQL Performance Tuning for Developers: http://www.informit.com/store/oracle-sql-performance-tuning-for-developers-livelessons-9780134117027 6+ Hours of Video Instruction The focus of Oracle SQL Performance Tuning for Developers LiveLessons is to illustrate coding techniques that ensure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements. Description In this video training, Dan Hotka starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This course then goes in-depth on understanding and controlling the Explain Plan, which is how and in what order Oracle retrieves data. The discussion includes considerable detail, with SQL examples, on how the optimizers--both rule-based and cost-based, but mostly cost-based--make their decisions. Students will work with a variety of SQL statements, reviewing Explain Plans and making changes to make these SQL statements perform better. Lectures include index design, using hints and coding style to control the Explain Plans, and how to use useful tools such as index monitoring, SQL Trace, and the PL/SQL profiler. This LiveLessons course takes a close look at indexes: how Oracle selects them, why they are sometimes not used, and how to tell if indexes are being used. This course includes Oracle10g, Oracle11g, and Oracle12c SQL tuning topics. Skill Level Intermediate Learn How To Read and understand Explain Plan content Review an Explain Plan and tell quickly if this is a good plan Understand a good index column candidate from a not-so-good candidate Quickly tell the likelihood if your SQL will use an existing index Use coding and a variety of Hints (directives) that can produce better performing SQL Execute and interpret SQL trace output Who Should Take This Course Oracle programmers Oracle database administrators who need additional training on SQL tuning Course Requirements Working knowledge of the SQL query language http://www.informit.com/store/oracle-sql-performance-tuning-for-developers-livelessons-9780134117027
Views: 3263 LiveLessons
Reading Oracle SQL Execution Plans - Practice Makes Perfect
 
01:40
To tune a SQL statement, you need to understand the execution plan. Can you identify the 1st step in an execution plan? The 2nd? The 3rd? In this short tutorial, Oracle Certified Master DBA John Watson of SkillBuilders uses a MERGE JOIN to help you understand how to find the order of execution, essential for SQL tuning.
Views: 1338 SkillBuilders
Oracle Database SQL Tuning with Constraints - Lesson 1 of 5
 
00:54
Learn how to tune SQL - especially in Data Warehouse environments - with Constraints. Constraints provide critical information to the Cost Based Optimizer in the Oracle Database. Don't drop your constraints for query performance! In these 5 lessons, Oracle Certified Master DBA John Watson will demonstrate how constraints - unique, foreign key, not null - improve the execution plan and thus performance of SQL in an Oracle database. View all 5 lessons, free at http://www.skillbuilders.com/oracle-database-sql-tuning-with-constraints.
Views: 915 SkillBuilders
Cost Based Optimizer Framework for Spark SQL: Spark Summit East talk by Ron Hu/Zhenhua Wang
 
31:42
In Spark SQL’s Catalyst optimizer, many rule based optimization techniques have been implemented, but the optimizer itself can still be improved. For example, without detailed column statistics information on data distribution, it is difficult to accurately estimate the filter factor, cardinality, and thus output size of a database operator. With the inaccurate and/or misleading statistics, it often leads the optimizer to choose suboptimal query execution plans. We added a Cost-Based Optimizer framework to Spark SQL engine. In our framework, we use Analyze Table SQL statement to collect the detailed column statistics and save them into Spark’s catalog. For the relevant columns, we collect number of distinct values, number of NULL values, maximum/minimum value, average/maximal column length, etc. Also, we save the data distribution of columns in either equal-width or equal-height histograms in order to deal with data skew effectively. Furthermore, with the number of distinct values and number of records of a table, we can determine how unique a column is although Spark SQL does not support primary key. This helps determine, for example, the output size of join operation and multi-column group-by operation. In our framework, we compute the cardinality and output size of each database operator. With reliable statistics and derived cardinalities, we are able to make good decisions in these areas: selecting the correct build side of a hash-join operation, choosing the right join type (broadcast hash-join versus shuffled hash-join), adjusting multi-way join order, etc. In this talk, we will show Spark SQL’s new Cost-Based Optimizer framework and its performance impact on TPC-DS benchmark queries.
Views: 994 Spark Summit
Oaktable World 2014 Jonathan Lewis on Calculating Selectivity
 
46:13
Oaktable World 2014 Jonathan Lewis on Calculating Selectivity
Views: 1063 kyle Hailey
The Evils of Implicit Conversions and other SQL Skullduggery
 
50:27
Presented by Tom Kyte Thurs 21st June 2012 Summary SQL and PL/SQL are deceptively simple, user-friendly languages, which is great for productivity, but also makes it relatively easy to write bad, non-scalable code. Certain features, in particular, seem to sound an irresistible siren call into a world of Oracle applications that perform poorly and yield unpredictable results. In this webinar, Tom Kyte, a Senior Technical Architect at Oracle Corporation, and the man behind asktom.oracle.com, takes a look at a few of the worst offenders: Triggers - much trickery is possible via triggers, and much of it causes pain, confusion and unexpected side effects Indexes, NULLs and cardinality - misinformation abounds with regard to the effect of NULLs on cardinality estimates, and the impact of NULLs on index use Implicit conversions - strings to numbers, strings to dates, raw to string... probably #2 on the list of 'bugs I see time and time (and time) again' With Tom's typically example-driven approach, you'll see first-hand evidence of the damage caused when fundamental features are misused, misunderstood and implemented badly. A live Q+A session with Tom follows the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 593 Redgate Videos
How to Think Like the SQL Server Engine, Part 3: Statistics and Memory Grants
 
17:25
Why does one query get wildly different execution plans? Learn how statistics influence your query plans, discover how to see your own statistics, and understand how stats help build memory grants.
Views: 7519 Brent Ozar Unlimited
Cost Based Optimizer in Apache Spark 2 2 continues -  Zhenhua Wang &  Wenchen Fan
 
31:24
Apache Spark 2.2 ships with a state-of-art cost-based optimization framework that collects and leverages a variety of per-column data statistics (e.g., cardinality, number of distinct values, NULL values, max/min, avg/max length, etc.) to improve the quality of query execution plans. Leveraging these reliable statistics helps Spark to make better decisions in picking the most optimal query plan. Examples of these optimizations include selecting the correct build side in a hash-join, choosing the right join type (broadcast hash-join vs. shuffled hash-join) or adjusting a multi-way join order, among others. In this talk, we'll take a deep dive into Spark's cost based optimizer and discuss how we collect/store these statistics, the query optimizations it enables, and its performance impact on TPC-DS benchmark queries. Talk contributors: Zhenhua Wang (Huawei Technologies) and Wenchen Fan (Databricks) Session hashtag: #SFdd2
Views: 780 Databricks
Oracle Database SQL Tuning with Direct and Indirect Reads
 
08:12
Oracle Database SQL Tuning tutorial. Learn what direct and indirect reads are and what impact they have on tuning SQL in Oracle Database. In this free tutorial from www.SkillBuilders.com, Oracle Master DBA John Watson will explain and demonstrate what direct / indirect reads are, pros and cons, why they can cause instability in the performance of your SQL (unpredictable response time), why stored outlines, SQL plan baselines and hints usually don't help. Perhaps most importantly, John will tell you what you can do about it. Intended Audience: Experience Oracle DBA's, developers and anyone with Oracle SQL tuning experience.
Views: 1732 SkillBuilders
Why Won't Oracle Use My Index - 12c Attribute Clustering - Lesson 1
 
01:46
Sometimes a poor clustering factor is the cause when Oracle Database cost based optimizer does not choose to use an index. With Oracle 12c (12.1.0.2 EE) offers a new feature that can really help - "Atrribute Clustering". This is implemented with a new keyword on CREATE TABLE - "CLUSTERING BY LINEAR ORDER". In this Free Tutorial from SkillBuilders and Oracle Certified Master DBA John Watson, you'll get a brief refresher on clustering factor and a demonstration of CREATE TABLE - "CLUSTERING BY LINEAR ORDER" - so the CBO will use your index! In this first lesson, John will provide a brief review of clustering factor. See all 6 lessons - FREE - at http://www.skillbuilders.com/12c-attribute-clustering
Views: 422 SkillBuilders
"Why We Built Our Own Distributed Column Store" by Sam Stokes
 
42:41
How do you understand the behaviour of complex distributed systems in production? Distributed systems can fail in unpredictable, hard-to-detect ways. To track down problems quickly, you need to look for patterns and correlations in your data, trying different ways of breaking it down. "Does the problem occur on just one host, or one partition, or for particular customers?" Sub-second complex queries over large data volumes in real time: sounds like a tall order. The Scuba paper from Facebook describes an architecture that can do it: a low-latency, distributed, schemaless database. Scuba achieves fast queries by storing all data in memory. It stores the raw events, and fans out queries to multiple nodes, so it can support complex queries including aggregates (like mean and percentile statistics) and breakdowns by fields of arbitrary cardinality. Building Honeycomb, we needed a database with these properties, but we had additional constraints: multi-tenancy, cost to serve, and the limited resources of a startup. This talk describes Retriever, a custom-built database inspired by Scuba. Retriever ingests events from Kafka, and chooses disk over memory, using an efficient column-oriented storage model. I'll discuss interesting aspects of the implementation, and lessons learned from operating a hand-rolled database at production scale with paying customers. Sam Stokes HONEYCOMB Sam Stokes is a software engineer who can't leave well enough alone. He's compelled to fix broken things, whether they are software systems, engineering processes or cultures. After watching too many systems catch fire, he's building better smoke detectors at Honeycomb; in a past life he cofounded Rapportive and built recommendation systems at LinkedIn.
Views: 5833 Strange Loop
How is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1 (by Amit)
 
10:22
In this video, you will understand how is the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Particularly, you will see the usage of EQ_ROWS & AVG_RANGE_ROWS. Learn about Amit Bansal’s ultimate video course on SQL Server Performance Tuning: http://bit.ly/abvideocourse Stay Connected with Amit Bansal and subscribe to the exclusive list of his session attendees (conference and pre-cons), class participants & video viewers. You will get just one email in two weeks with good links to continue your learning. http://bit.ly/connectwithab Also, you can join ‘SQLMaestros Champs’ Telegram group and participate in SQL Server discussions. It’s a forum for SQL Server lovers - https://t.me/joinchat/AnAGwxBU1KXORoUR9jD_dw If you work on other technologies in MS Data + AI Stack, join this group: http://www.dataplatformgeeks.com/dpg-mobile/ Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ - http://www.twitter.com/SQLMaestros - https://www.facebook.com/SQLMaestros - Email us: [email protected] Data Platform Summit Asia's largest learning event on AI, Data & Advanced Analytics. https://www.dps10.com/ SQLMaestros Video Courses Amit Bansal’s popular SQL Performance Tuning course is now going live in video format. http://sqlmaestros.com/sql-server-videos-courses/ SQLMaestros Hands-On-Labs Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere. http://hols.SQLMaestros.com Email [email protected] SQLMaestros Learning Kits The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. https://sqlmaestros.com/sql-server-courseware/ SQL Server Health Check If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. https://sqlmaestros.com/sql-server-health-check/ Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 Our Telegram group on mobile http://www.dataplatformgeeks.com/dpg-mobile/ DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development If you wish to speak at DataPlatformGeeks events, fill out this form: http://www.dataplatformgeeks.com/call-speakers-dpg-events/ If you wish to become a Regional Mentor with DataPlatformGeeks, fill out this form: http://www.dataplatformgeeks.com/become-regional-mentor/ Watch all recorded DPG webinars here: www.youtube.com/SQLServerGeeks
Views: 879 SQLMaestros
What is difference between Temporary Table & Table Variable|| Temp table Vs Table Variable
 
14:36
In this video, I explained SQL most important questions which are commonly asked in the interview. What is difference between Temporary Table & Table Variable|| Temp table Vs Table Variable This video is very helpful to crack interview for SQL Developer, Database Developer, Business Analyst, System Analyst, Reporting Analyst etc #SQL, #TempTable, #TableVariable -------------------------------------------------------------------------------------------------------- Online Training contact to [email protected] --------------------------------------------------------------------------------------------------------- Data Science Tutorial for Beginners: https://www.youtube.com/watch?v=ejWEe8HxjRU&list=PLegYZKhkVmVfXAc_RSbKl2S6H9O2RMjX4 ---------------------------------------------------------------------------------------------------------- SQL Interview Questions and Answers: https://www.youtube.com/watch?v=VC0XITkFpPo&list=PLegYZKhkVmVdnrlPM9NGmckrIbQBPOki5 ---------------------------------------------------------------------------------------------------------- Share, Support, Subscribe: https://www.youtube.com/channel/UCYFaYAv3R_0vGd7nB508PbQ ---------------------------------------------------------------------------------------------------------
Views: 132 StudyIT Education
Simplified DBA-023-01-SQL Plan Management   EXPLAIN PLAN
 
10:04
Optimizer needs statistics to create an execution plan for each query.
Oracle default Buyer Assign to Category
 
07:38
Oracle default Buyer Assign to Category workaround Solution 1- Oracle Order management part 1 : Order to Cash https://www.youtube.com/watch?v=kdqgXH5H_EQ&list=PLUPZzKDNkYEzt7Q8VOZV_w0oznZ-owtc_ 2- Oracle Order management part 2 : Order to Cash Complete life Cycle https://www.youtube.com/watch?v=hkQvdkIoY-8&list=PLUPZzKDNkYEzt7Q8VOZV_w0oznZ-owtc_&index=2 3- Oracle Discrete manufacturer : Operation schedule trace part 1 https://www.youtube.com/watch?v=nkOgCohzhXI 4- Oracle Discrete manufacturing: schedule trace part 2 https://www.youtube.com/watch?v=4xfIvInEjVc 5- Oracle ATO ( WIP & Sales Order ) : Order to Make https://www.youtube.com/watch?v=wHJHTLGLAmo 6- Oracle Discover : capability & Key use training https://www.youtube.com/watch?v=R8Ic3Z6-evU 7- Oracle Global Order Promising : overview ATP/CTP/CTD https://www.youtube.com/watch?v=EmD9lN-6WiU 8- Oracle EBS Report Strategy https://www.youtube.com/watch?v=SbpDwmW6e2A 9- Oracle configuration to order: ATO ,PTO,hybrid,pre-configuration define item https://www.youtube.com/watch?v=f8pzoUGTEYU LinkedIn: shereifzoweal Oracle channel : www. youtube.com/c/ShreifZoweal
Views: 605 Shreif Zoweal
15a  Index Selectivity
 
00:40
Views: 88 B's March
Pearson Simplifies Licensing Costs by Moving their SQL Server Workloads to AWS
 
08:05
Learn more about Microsoft Workloads on AWS at - https://amzn.to/2U09taR. Pearson serves millions of students and thousands of educators worldwide. In this video, Ian Wright, VP of Infrastructure and Operations at Pearson, talks about Pearson's Schoolnet application migration journey. By moving to AWS, Pearson saw faster deployment times and cost savings of 30% with their SQL Server workloads compared to on-premises. They also took advantage of AWS License Manager to simplify their Microsoft license management.
Views: 681 Amazon Web Services
SQL Tuning with Oracle Database 12c Histograms
 
09:20
Learn the new 12c options for creating histograms. See all free video tutorials at http://www.skillbuilders.com/free-oracle-tutorials. In this free tutorial, Oracle Certified Master DBA John Watson demonstrates what histograms do (provide correct cardinality), the difference between histogram types (Frequency and Height Balanced). You will also learn the importance of the auto sample size algorithm in 12c and the new "Hybrid" and "Top Frequency" type histograms.
Views: 3987 SkillBuilders
15  Index Selectivity
 
02:36
Views: 173 B's March
1Z0-064 Oracle Database 12c: Performance Management and Tuning
 
07:23
1Z0-064 Oracle Database 12c: Performance Management and Tuning http://exampasser.com/ExamPasser/ExamInfo.aspx?d=Oracle&c=1z0-064&q=1 USE THE CODE "FOE2013" TO GET 15% DISCOUNT
Views: 297 Exam Passer
Query Tuning 101 What to Look for in Autotrace Output
 
02:58
You're up and running with autotrace, looking at the actual execution plan for a query. Now the real work begins! What is it you're actually looking for in the execution plan? This video shows what you need to investigate and how to use the HotSpot feature of SQL Developer 4.1 to highlight parts of the query you need to pay attention to. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 8771 The Magic of SQL