Home
Search results “Oracle using hints index”
Oracle Hints Tutorial for improving performance
 
10:35
Oracle Hints Tutorial for improving performance APPEND PARALLEL JOIN INDEX NO_INDEX SELECT /*+ FIRST_ROWS(10) */ * FROM emp WHERE deptno = 10; SELECT /*+ ALL_ROWS */ * FROM emp WHERE deptno = 10; SELECT /*+ NO_INDEX(emp emp_dept_idx) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; SELECT /*+ INDEX(e,emp_dept_idx) */ * FROM emp e WHERE e.deptno = 10; -- SELECT /*+ INDEX(scott.emp,emp_dept_idx) */ * FROM scott.emp; SELECT /*+ AND_EQUAL(e,emp_dept_idx) */ * FROM emp e; SELECT /*+ INDEX_JOIN(e,emp_dept_idx) */ * FROM emp e; SELECT /*+ PARALLEL_INDEX(e,emp_dept_idx , 8) */ * FROM emp e; SELECT /*+ LEADING (dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; SELECT /*+ PARALLEL(8) CACHE (e) FULL (e) */ * FROM emp e ; SELECT /*+ PARALLEL FULL (e) */ * FROM emp e ; SELECT /*+ PARALLEL USE_MERGE (emp dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; -- SORT Merge Join SELECT /*+ PARALLEL USE_HASH (emp dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; -- Hash Join SELECT /*+ PARALLEL */ * FROM emp e ; INSERT /*+ APPEND */ INTO mytmp select /*+ CACHE (e) */ *from emp e; commit;
Views: 8440 TechLake
Oracle 11g Hints Overview
 
42:56
In this Video tutorial we will discuss about Optimizer hints in Oracle. What is optimizer hint, when & why its needed. Different Category of hints. Description of mostly used hints. Demonstrate how query plan can change with the influence of hint.
Views: 53171 Anindya Das
Oracle Hints Tutorial for improving performance with examples
 
11:16
Oracle Hints Tutorial for improving performance with examples Oracle Hints Oracle Tutorial for beginners SQL Tutorial for beginners SQL Hints SQL Performance tuning
Views: 3851 TechLake
SQL: Optimizer Hints Part-1
 
05:56
In this tutorial, you'll learn...what are optimizer hints and how to use it.. SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Views: 20433 radhikaravikumar
Why Use Parallel Processing?
 
03:20
This video compares the use of parallel and serial processing for the same SQL query. 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 SQL Performance Tuning: 4/4] Basic Hints and their Usage
 
30:52
This presentation explains how to use basic hints of Oracle. The series of SQL tuning videos presents performance tuning tips for developers. For presentation used in this video, please visit: https://drive.google.com/drive/folders/0B6EDqGZwjejmWng5VWM3ZEtaNzA?usp=sharing
Views: 10942 anilkumar ghorakavi
SQL: Optimizer Hints Part-2
 
05:06
In this tutorial, you'll learn...what are optimizer hints and how to use it.. SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Views: 11799 radhikaravikumar
Oracle Hints explained
 
42:56
Oracle Hints
Views: 535 Telugu Blast News
Oracle Database Indexes: Myths, Tips and Tricks
 
09:04
In this tutorial, OCM John Watson will - via demonstrations - debunk these myths: Myth #1: Oracle Database does not index NULL Myth #2: A search that includes wildcards can't use an index if the wildcard precedes the string. Myth #3: Oracle will not use a function-based index unless the FBI is coded in the predicate. Myth #4: Indexes always help. The more indexes the better. See http://skillbuilders.com/free-oracle-tutorials for gigabytes of free Oracle video tutorials.
Views: 16321 SkillBuilders
Hints
 
08:04
Hints watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Optimizer Statistics
 
11:10
Optimizer Statistics watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
Oracle DBA - Solve Long Running Query & TX Row Lock Contention | Performance Tuning
 
09:19
How to Solve Row Lock Contention in Oracle Database - Performance Tuning - Oracle DBA Solve Row Lock Contention & Long Running Query in Oracle Database - Performance Tuning Oracle DBA - Performance Tuning Row Lock Contention Please Like, Comment, Subscribe and Share... Boxcut Media.
Views: 7867 BoxCut Media
Oracle Performance Tuning - Read and interpret Explain Plan
 
17:43
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 41636 itversity
Why Isn't My Query Using an Index?
 
47:01
“Why isn’t my query using an index?” is a common question people have when tuning SQL. This session explores the factors that influence the optimizer’s decision to answer this question. It does so by comparing fetching rows from a database table to finding all the red M&Ms a packet, and contrasts using an index range scan and a full table scan. It also introduces the concepts of blocks and the clustering factor. The session offers a discussion of how these affect the optimizer's calculations, and includes a demo of how these concepts work in practice using real SQL queries. This session is intended for developers who want to learn the basics of how the optimizer chooses between an index range or full table scan. Speaker: Chris Saxon
Views: 293 Oracle Developers
Oracle Hints,
 
02:33
Oracle Hints, Tips and advice - Hints and tips on various programming languages and development tools.
Views: 3851 018sube
Using B*Tree Indexes-When to use B*Tree Indexes(Indexes in Oracle-3)
 
31:14
 This video will cover  When B*Tree Index should be used. We will try to understand some of the situations when the optimizer will use B*Tree Index.  Index Clustering Factor .  Influence of parameter Optimizer_Mode and Optimizer_index_cost_adj on using B*Tree Index.
Views: 13391 Anindya Das
Oracle SQL Tutorial : Using execution plan to optimize query in oracle
 
12:54
Oracle SQL Tutorial Oracle tutorial: Explain plan for query optimization in Oracle PLSQL oracle tutorial for beginners using execution plan to optimize query sql query analyzer sql query cost analysis https://techquerypond.wordpress.com This oracle tutorial show you how to use EXPLAIN PLAN in oracle. This video covers how to check cost of the query from DBMS_XPLAN.DISPLAY . You can find the cost of the query using the Using EXPLAIN PLAN FOR and based on the result you can optimize the query for faster performance. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://twitter.com/techquerypond
Views: 13125 Tech Query Pond
Why Has an Index Broken My Query?
 
06:02
Sometimes Oracle can give unexpected exceptions. This often happens when working with dates stored as strings. In this video, Chris investigates why adding an index to a varchar storing dates could cause a query to fail. He explains why this happens. Then he shows workaround to avoid this. You can download the scripts in this video from LiveSQL at: https://livesql.oracle.com/apex/livesql/file/content_CVN82PZQWQSUFYMOVKG0VI19T.html ============================ 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: 2965 The Magic of SQL
Oracle Parallelism Concepts
 
20:42
Oracle Parallelism Concepts
Views: 2112 The Silent DBA
Using Parallel and Cardinal Hint
 
07:44
This is a demo on using Parallel and Cardinal Hint to tune queries in ILM.
Views: 1324 Informatica Support
Oracle Performance Tips - Indexes
 
03:58
Learn about index and types of indexes.
Views: 2297 Saurabh Kumar
Hints and Tips - Using NULLIF in SQL
 
01:58
An easy method to avoid divide by zero by using NULLIF ========================================­­­­­============== 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: 2406 Connor McDonald
Oracle Hints - FIRST_ROWS - Example
 
02:17
Excerpt from "Oracle sql tuning-advanced" video tutorial training. www.dbvidya.com/course/sql-tuning-advanced/ [email protected] +91 991 2323 000 Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-performance-tuning-videos/ Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-awr/ Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-tool/ ER Data Modeling Course : http://www.dbvidya.com/course/er-modeling/ Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensional-modeling/ Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 221 DbVidya
How can I speed up a query if an index cannot help?
 
08:20
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 1316 Connor McDonald
What do you mean the Oracle Optimizer won't use my Index
 
47:15
Learn some details about how the Oracle optimizer works with Themis instructor John Mullins.
Views: 675 Themis Education
SQL Tutorial For Beginners SQL INDEXES  BITMAP and B-Tree
 
28:08
Oracle SQL Index types with examples. Simple Index, Composite Index, Unique Index, Non Unique Index, Bitmap Index, B-tree Index. SQL Tutorial SQL Tutorial for beginners Oracle SQL Tutorial for beginners
Views: 20818 TechLake
【VDEDU】Unusable indexes use
 
06:29
Unusable indexes in Oracle, DML statements are not use the index to its maintenance, at the same time the optimizer will not use the index. Unusable indexes no segment exists. Unavailable index index becomes available methods are: 1. Place the index can not be truncate operation corresponding table; 2.rebuild index; In addition, the query optimizer can use conversion method expand table so that the SQL statement has encountered unusable index partition table to generate better execution plans.
Views: 65 崔旭
Missing Index Hints in SQL Server Management Studio by Amit Bansal
 
16:24
In this video, you will learn why you should not blindly follow the SSMS Missing Index Hints. 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] Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 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 Do you know about Data Platform Summit? http://www.DPS10.com
Views: 1266 SQLMaestros
B*Tree Index Fundamentals(Indexes in Oracle-1)
 
17:42
Part -1 : Introduction to Indexes, B*Tree Indexes, Index scan methods. Part -2 : B*Tree Index Types(different types of B*Tree indexes) Part -3: Using B*Tree Indexes(When use B*Tree indexes, factors related to B*Tree Access) Part -4 : Index Organized Table Part -5 : Bitmap Indexes Part -6: Partitioned Indexes Part- 7: Other type of Indexes based on characteristics & use. Part -8: Managing Indexes
Views: 49602 Anindya Das
Hints and Tips - A silent movie on joins
 
02:31
The vision says it all ... a basic primer on how joins are performed in Oracle, using the metaphor of playing cards. Enjoy... ========================================­============== 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: 1997 Connor McDonald
ORACLE SQL  Optimizer Hints with example
 
05:56
ORACLE SQL Optimizer Hints with example
Views: 84 Gees info
Oracle Database Performance Tuning for Admins and Architects
 
48:59
Product manager Randal Sagrillo asks you to be a hero as an administrator or architect in the practice of performance tuning!
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: 3428 LiveLessons
Oracle Database Hints Tuning Tips Presentation Video Oracle DB
 
05:28
For a quick reference on oracle visit http://PocketORACLE.blogspot.com
Views: 5065 TheEzguide
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: 3181 LiveLessons
Making Smart Scan for Exadata Work (Demonstration)
 
03:16
Making Smart Scan Work - Demo I'll go through a simple example of the kind of thing we need to think about when trying to achieve Smart Scan. Let me just enable tracing, run a simple query, select and * from *. Now, there's my query. The result set comes back, and how is it executed? An index full scan with the PK* index. The optimizer is intelligent enough to know that my query can be satisfied purely by reading the index and therefore it didn't have to go to the table at all. It looks very good. Well, it wasn't. Index full scans are an operation that cannot be offloaded. So, to execute that statement, every block of that index was delivered into the buffer cache of my own database instance, and the compute node then has to do the work of extracting those values. What can we do about it? One solution would be to hint the code. I select and demand an index fast full scan, and now we see the magic word "storage." An index fast full scan is offloadable, because an index fast full scan can do direct reads. An alternative approach? Well, you might not want to hint many, many thousands of lines of code. An alternative approach would be to do it through DDL. For example, take that index, make it invisible. Now run my statements without any hint at all, table access storage full, and that was offloaded. Having made the index invisible, Oracle has no option but a full-table scan, and a full-table scan is offloadable. Now, this means I have three options of this very simple example. I can let the optimizer get on with what it wants to do, and then I use an index that I'm doing block serving into the buffer cache. I can hint the code, index fast full scan. That's probably the best option for performance, but it's also the most work. In this intervening case, I make the index invisible so that it will still be used of course for enforcing the primary key constraints, but it will not be visible to the optimizer and therefore influence the optimizer towards using plans that can be offloaded the Smart Scan. Making the choice between this and influencing the optimizer in the correct direction is an extremely difficult job, and it is not always easy to determine what is going to be the best solution.
Views: 3434 SkillBuilders
SQL Server Execution Plan Query Hints
 
24:18
SQL Server Execution Plan Query Hints
Views: 687 Geek Tamizhan
Are my index statistics wrong?  Why does NUM_ROWS equal zero?
 
06:27
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 288 Connor McDonald
B*Tree Index Types (Indexes in Oracle-2)
 
33:58
This video will cover different types of B-tree indexes: Descending index,Reverse key index,Key Compressed Index B-tree cluster index,Index Organized Table(IOT):
Views: 15483 Anindya Das
SQL: Explain Plan for knowing the Query performance
 
05:17
In this tutorial, you'll learn how to compare queries to know the better performance query..
Views: 99412 radhikaravikumar
Oracle Optimization - Table Partitions
 
15:07
Oracle optimization: create table partitions and Index-Organized Table. Other lessons, visit http://www.learn-with-video-tutorials.com/plsql-oracle-optimization
Stop Rebuilding Global Indexes! Oracle 12c Global Index Maintenance
 
09:00
Stop rebuilding Global Indexes! Stop worrying about invalidating Global Indexes! Oracle 11g gave us "UPDATE GLOBAL INDEXES". 12c provides a huge improvement: orphaned_entries! In this tutorial, Oracle Certified Master John Watson demonstrates how 11g and 12c handle Global Index maintenance with orphaned entries and overnight maintenance job PMO_DEFERRED_GIDX_MAINT_JOB.
Views: 2542 SkillBuilders
Oracle SQL Performance Tuning
 
07:40
A beginner's guide that shows you how to start on SQL Performance tuning with reference to Oracle. Talks about plans, indexes and hints. Visit the associated web page at http://blog.hardeep.name/computer/20090217/sql-tuning/ For those unable to understand the accent, or looking for a more advanced tutorial visit http://blog.hardeep.name/general/20090711/app-tuning/
Views: 55570 dwealth
Oracle Indexes - Live Demonstration
 
19:12
When is a Full Table Scan faster than an Index Scan? Watch Ross and Jordan act out an Oracle database reading and caching data via both methods, explaining the costs and benefits in simple and easy to understand terms. The demonstration is part of a talk by Ross Leishman of DWS Ltd on the principles of Understanding Indexes for SQL Tuning. The full lecture is at this link: https://www.youtube.com/watch?v=Z4hKomnGHFA DWS Ltd is a leading publicly listed Australian IT Services company, providing services to blue chip organisations since 1991. With a business philosophy based upon integrity, reliability and professional service delivery, DWS provides end to end IT solutions. www.dws.com.au
Views: 2706 DWS Ltd
Oracle Performance Tuning - Materialized View
 
04:32
How to create and refresh materialized view
Views: 3680 Saurabh Kumar
SQL Query Hints
 
03:06
Hints are options and strong suggestions specified for enforcement by the SQL Server query processor on DML statements.
Views: 829 Fullon Baan
Hints and Tips - Queries running whilst exchanging partitions - part 2
 
01:26
Even when you rip out a partition from a table, queries can still execute successfully. ========================================­­­­============== 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: 1034 Connor McDonald
SQL Performance Tuning 2 and tips
 
10:56
SQL Performance Tuning 2 and tips Oracle Performance Tuning Oracle SQL Performance Tuning Tips
Views: 6244 TechLake
Parallelism in SQL
 
03:02
Parallelism in SQL watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
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: 66245 SkillBuilders