Oracle SQL Tips, Tricks and Hacks
Everything Oracle SQL
Menu Close
  • Blog
  • Video Courses
  • Oracle SQL Tutorial

optimizer

38

Count(*) Vs Count(1) Again?

Posted on January 31, 2017 by Carlos

I decided to write this article because the question about COUNT(*) Vs COUNT(1) keeps being asked, and I usually find myself explaining my answer again and again and/or looking for links to someone else’s articles that can help support my… Continue Reading →

SQL, Tuning 10053, count, count(*) vs count(1), COUNT(1), count(1) vs count(*) oracle, optimizer, query, Trace, Transformation
28

Understanding a Query’s Execution Plan

Posted on January 30, 2016 by Carlos

One of the most basic tasks you need to perform when tuning SQL statements is determining the causes of the performance problem, and to do that, you will most likely need to analyze the execution plan of the problematic statement.… Continue Reading →

SQL, SQL Developer, Tuning access path, autotrace, cost, execution plan, explain plan, Join, optimizer, SQL Developer, tuning
Don't want to miss any Oracle SQL tips?

Subscribe to be informed about new posts, tips and more awesome things.

Recent Twitter Activity

Recent Tweets by @CarlosDLG

Recent Posts

  • The SQL Group By Clause
  • The Oracle Multitenant Architecture
  • The FIRST and LAST functions in Oracle SQL
  • Pairwise Comparisons With Subqueries in Oracle SQL
  • How to Change Oracle SQL Developer Language

Categories

  • Basics
  • Functions
  • Oracle Database
  • SQL
  • SQL Developer
  • Tuning

Archives

  • March 2019
  • September 2018
  • April 2018
  • January 2017
  • October 2016
  • August 2016
  • June 2016
  • April 2016
  • January 2016
  • November 2015
  • October 2015
  • September 2015
  • August 2015
© 2021 Oracle SQL Tips, Tricks and Hacks. All rights reserved.
Hiero by aThemes
Shares