A Quick checklist on how to choose the right pl sql index type and what are the different points to consider while working on oracle Indices. Index is a database structure built (optionally) on top of a table for faster retrieval of data. indices help Improves the performance of a SQL.
Target Audience: – DB professionals who have 2 to 5 years of working experience on oracle database. What is Oracle DUAL table? why this dual table is needed?
Source of this write-up is Jeff (Name changed), who had a discussion with me about oracle analytic function. While having oracle analytic function discussed, I even had to resurface oracle aggregate functions. Just pushing it here for rest of us.
coming to the point, Oracle Analytic functions calculate Aggregate values based on data groups, that still sound similar to Aggregate functions is not it? So here is the main deal “Aggregate function returns one row for every data group as result wherein Analytic functions returns multiple rows for each data group.” Below we will see what are the different Analytic functions we have and how the Analytic clause Partition by is used..