I've moved...

This blog now has a new home - please update your shortcuts and readers to: www.jeffkemponoracle.com. Sorry for any inconvenience!

Wednesday, January 25, 2006

Simplify your SQL - Avoid Unnecessary Joins

Simplify your SQL - Avoid Unnecessary Joins

I can't count how many times I've seen SQL like the following:

SELECT b.some_column
FROM a, b
WHERE a.id = :p_id
AND b.id = a.id;


[Full Article]

No comments:

Post a Comment

Note: only a member of this blog may post a comment.