PL/SQL

April 16, 2007

Analytics Performance Comparison

Filed under: ANALYTICS, example, execution plan, explain plan, partitioned by, performance, PL/SQL, row_number, SQL — Michael Moore @ 9:01 pm

In this case Analytic SQL ran 99% faster than a more traditional approach.
The SQL problem being solved in the examples is getting the last 3 of each group.

This is my first attempt at using images for this blog. If you come to the web site, the images appear
somewhat reasonable sized. If you are viewing this through a feed reader, the images may appear
to be gigantic. I am thinking I will avoid images in the future.
I don’t know if this example really proves anything except that under these circumstances,
the analytics query is much faster than the traditional query.
If you think these results are atypical, or have any comments on this example, please leave a comment.
Also, ignore the /*xyzzy03*/ in the example; it is just a comment that I forgot to strip out.

page1

page2

page3

page6

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: