DB Optimizer diagrams 100 tables

February 12th, 2011

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.


  1. Trackbacks


  2. No comments yet.

one − 1 =