GROUP BY might be distinctly better than DISTINCT

(Connor McDonald) One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the source table(s) from which they are derived from, in real time or near real time.

Register to Read