Search

Top 60 Oracle Blogs

Recent comments

DB Optimizer diagrams 100 tables

People ask me what the limit is to the number of tables  in a SQL statement  that DB Optimizer can handle when tuning.  Above is a tiny thumbnail for a 100 table SQL statemement. The SQL actually only has a select from one view  but that view expands to 100 different tables. Pretty awesome.