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

Transformation

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
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