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 hope to do a complete
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 clauses doing similar work. But
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 value lists. The AVG() function
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 to order the data in
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 tuning and sorting queries but
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 was introduced in early Oracle
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 group filtered according to specific
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 to retrieve text, spatial, or
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 issue are headache. It’s because
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 used on Data manipulation. Data
Ennicode.com
Education Blog for Software Engineering
Subscribe to our Newsletter
Most Recent
Explore Design Patterns