Tag: performance

After the article “Count(1) or count(*) that is the question” I was asked about the proof that Oracle internally rewrites Count(1) into Count(*). Follow below steps and check for yourself 🙂 1. Create CNT_TEST table

2. Start TRACE 10053

3. Run query …

Oracle: COUNT(*) vs COUNT(1) – the final battle Read More »

Tagged with: , , , , , ,

Hire us!

Pretius is a software development company.
We create web applications using: Java, Oracle DB, Oracle Apex, AngularJS.
Contact us to talk about how we can help you with your software project!