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.