jump to navigation

Quote of the day (from Oracle’s Ask Tom) September 28, 2006

Posted by Andrew in Databases.
trackback

This blog has moved.

The new details are:

Blog: http://andrewpeters.net/

Feed: feed://http//andrewpeters.net/feed/

Advertisements

Comments»

1. James Newton-King - October 3, 2006

It is a good quote, although I think it is ironic that Tom then doesn’t actually say why a subquery is better than a join when no columns from the table are needed in the second :)

2. andrewpeters - October 3, 2006

Hi James, thanks for commenting. Although perhaps not directly related to the quote, he does point out that the two approaches can result in different answers. He also makes a good point about premature optimization – Strive to the clearest, most intention revealing code and let the optimizer (or compiler) figure out how to make it fast.


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

%d bloggers like this: