SQL tuning with Hashing and Sorting
Aggregation SQL is not all just primary key lookups, although some applications sadly see SQL as only useful in that
Tag: group by
GROUP BY better than DISTINCT for materialized views
One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the
LISTAGG hits prime time
It’s a simple requirement. We want to transform this: SQL> select deptno, ename 2 from emp 3 order by 1,2;
