Quote:
Originally Posted by n_i
I doubt that one can directly translate algorithmic complexity into query performance metrics.
|
Where on earth do you get the idea that he does? It is not the complexity of the algorithm but the straightforward nature of a theta join.
I really wouldn't dismiss Itzik Ben Gan's writings too lightly. He is easily up there in the top 10 of SQL Server gurus, and very possibly the very top T-SQL expert on the planet.