Analytic Functions By Example

Analytic functions by Example : "This article provides a clear, thorough concept of analytic functions and its various options by a series of simple yet concept building examples. The article is intended for SQL coders, who for might be not be using analytic functions due to unfamiliarity with its cryptic syntax or uncertainty about its logic of operation. Often I see that people tend to reinvent the feature provided by analytic functions by native join and sub-query SQL. This article assumes familiarity with basic Oracle SQL, sub-query, join and group function from the reader. Based on that familiarity, it builds the concept of analytic functions through a series of examples." On the last couple of tuning engagements I've been on, it's been the deployment of analytic functions to replace expensive subqueries that have delivered the big payoff early on in the project. This article by Shouvik Basu, and also an article on the same subject by Jonathan Lewis, are good introductions to analytic functions and a good complement to the online documentation.