Oracle COALESCE vs NVL Performance
Asiri Gunasena
December 11, 2023
Once comparing the Oracle COALESCE vs NVL performance most of the searches say those are mostly equal. But I also
Menu
Read More »
How to Change DISTINCT vs GROUP BY Performance Oracle
Asiri Gunasena
December 4, 2023
Distinct vs Group By performance oracle can be changed due to several conditions. Generally, Both are Distinct and Group By
How to Use Average in SQL Oracle: 5 Simple Examples
Asiri Gunasena
November 27, 2023
The average in SQL Oracle function is an aggregate and analytic function taking an average of a set of numeric
Oracle ORDER BY Index | How to Perform? | 6 Examples
Asiri Gunasena
November 20, 2023
Oracle order by index is a good option to sort data by improving performance. Sorting is used when you want
Ultimate Guide To Oracle Order By Performance 10 Tips
Asiri Gunasena
November 20, 2023
Oracle order by performance is considered more often when doing performance improvements. There are lots of techniques are help in
How to Change Case vs Decode in Oracle Performance
Asiri Gunasena
November 6, 2023
How to change case vs decode in Oracle performance? Performance change oracle decode vs case is simple and easy. DECODE
How To Use Rank Function in Oracle: 5 Real-World Examples
Asiri Gunasena
October 30, 2023
The rank function in Oracle is a useful tool that gives a rank on each row in the specific data
How To Create Oracle Domain Index: Definition And 5 Examples
Asiri Gunasena
October 23, 2023
What is domain index in Oracle? oracle domain index is a specialized type of index in Oracle that is used
Love to Performance : CONNECT BY PRIOR in Oracle Performance Issue
Asiri Gunasena
November 21, 2023
CONNECT BY PRIOR clause is Oracle provided a great solution for hierarchical queries but connect by prior in Oracle performance
Oracle REPLACE Function: The Data Cleanup Magic
Asiri Gunasena
October 10, 2023
Oracle provides a powerful set of functions for working with data. In such cases, the Oracle REPLACE function can be
Ennicode.com
Education Blog for Software Engineering
Subscribe to our Newsletter
Most Recent
Explore Design Patterns