Execution Plans Archives | Official TuningSQL.com Blog
Skip to content
  • TuningSQL.com
  • TuningSQL.com
Official TuningSQL.com Blog

Official TuningSQL.com Blog

Oracle Database SQL, Tuning, Features, and Toubleshooting

Category: Execution Plans

  • Home
  • Oracle
  • Tuning/Efficiency
  • Execution Plans

How to Get A Query’s Execution Plan (With All The Details)

January 10, 2021January 10, 2021 Kaley Crum

In Oracle, if you want to view an execution plan for a query, you use the DBMS_XPLAN.DISPLAY_CURSOR() procedure. NOTE: The execution plan is totally different than an explain plan; don’t confuse these two. The easiest way to get an execution… Read More

Execution Plans, Oracle, Tuning/Efficiencyexecution plan, execution plansLeave a comment

How to Get Row Source Statistics In Oracle

January 7, 2021January 7, 2021 Kaley Crum

One great way to get time analysis information for a query in Oracle is to use row source statistics. Not everyone has the tuning and diagnostic pack, meaning not everyone can generate SQL Monitor reports. Row source statistics serves as… Read More

Execution Plans, Oracle, Row Source Statistics, Tuning/EfficiencyLeave a comment

Index Range Scan vs. Leading Wildcard

July 2, 2020August 13, 2020 Kaley Crum

Can you use an index range scan with a LIKE if you have a leading wildcard in your expression? e.g. Most people would say “no” but, I actually found a way to “trick” Oracle into doing so using bind variables,… Read More

Bind Variables, Execution Plans, OracleLeave a comment

When to Use APPROX_COUNT_DISTINCT

January 5, 2020August 13, 2020 Kaley Crum

Since Oracle 12.1, users have had the ability to use the APPROX_COUNT_DISTINCT() function. This function is supposed to be significantly faster than a COUNT(DISTINCT …). Does it really offer that big of a payout? Let’s see: First, let’s make a… Read More

Approximate Query Processing, Execution Plans, Oracle, Tuning/Efficiencyapprox, approx_count_distinct, memoryLeave a comment

What is Cost? How Can I Use It to Tune SQL?

September 3, 2019August 13, 2020 Kaley Crum

When most people first start learning to tune SQL, they develop a fascination with this mysterious column on the execution plan called “cost.” What is cost? And how can you use it to tune SQL? So here’s, high level, what… Read More

Execution Plans, Explain Plans, Oracle, Tuning/EfficiencyLeave a comment

FREE Sql Tuning Tips!

Get FREE tips and tricks for FASTER Oracle SQL queries delivered directly to your email inbox!

Just a minute...

Awesome! You're subscribed!!

Recent Posts

  • How to Make a “God User” in Oracle
  • View Hidden Parameters in Oracle
  • KUP-01005: syntax error: found “hash” (How to fix on an External Table)
  • Finding mod(power(x,y)) for Larger Values
  • Writing Efficient Pl/SQL is Hard

Categories

  • Approximate Query Processing
  • Arrays
  • Autonomous
  • Baselines
  • Bind Variables
  • Caching
  • Certification
  • Creating Users
  • Cursors
  • Custom Aggregation
  • Data Dictionary Views
  • Data Types
  • Database Objects
  • Day to Second Interval
  • DBMS_METADATA
  • DBMS_UTILITY
  • Dirty Hacks
  • Execution Plans
  • Explain Plans
  • External Table Problems
  • FORALL
  • Hash Clusters
  • Hash Joins
  • Hints
  • Keywords
  • Network Connections
  • NULL Values
  • NULL Values
  • Oracle
  • Oracle Error Messages
  • Oracle SQL Developer
  • Parameters
  • Pl/SQL
  • Pl/SQL Compiler Flags
  • Pluggable Databases
  • Pragmas
  • Privileges
  • Problems and Troubleshooting
  • Regular Expressions
  • Row Level Security
  • Row Source Statistics
  • Scalar Subqueries
  • Scripts and Queries
  • SQL
  • SQL Monitor Reports
  • SQL Plan Management
  • Table Definition
  • Table Statistics
  • Tuning/Efficiency
  • Uncategorized
  • User Profiles
  • Users
  • Version
  • Virtual Columns
  • Wrapping Pl/SQL Code
  • Writing Queries for Performance
Copyright © TuningSQL.com All rights reserved.
Business Cast by Axle Themes