Analytic Functions By Example
January 15th, 2005 by Mark Rittman
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.
January 18th, 2005 at 10:23 pm
I’d love to read the referenced article, but orafaq.com is refusing all connections. [sigh]
January 19th, 2005 at 3:12 pm
Strange. When I tried to read the article yesterday, the connection to orafaq.com timed out. Today, clicking the link says 404 page not found.
When I try to connect to the top level, http://www.orafaq.com, FireFox complains that the site’s certificate name (air891.startdedicated.com) doesn’t match the site name (orafaq.com).
Do you have a copy of this article so we can (safely) view it?
Thanks,
Stew
January 19th, 2005 at 7:33 pm
Stew, you’re right, it does appear to be down (at least the /articles bit). I would guess that the /articles bit is run on a different server (it’s an MT installation) and the hosting has gone a bit wrong. Unfortunately I don’t have a copy so we’ll have to wait until it comes back up again. Sorry.