Thanks to everyone who came out to see my presentation on cartesian products at the Northeast Oracle User's Group (NOUG) on March 5th, 2008. I'd also given the presentation at Data Management Association (DAMA) in April 2007. Hopefully, the word will circulate, and we can help stamp out cartesian products.
As promised, I have made the slides available to those who want them.
(right click, and then save.)
If you want to experiment with SQL queries on the same schemas, you can also download the schemas too.
Schema Carter contains 240 rows in the table with the most rows.
Schema Carter2 contains the same table structures, but have 1000 times more rows in each table, for a maximum of 240,000 rows.
You can contact me at the email addresses found at the end of the presentation.
Copyright © Rodger Lepinsky. All Rights Reserved