Home Forums Article Discussions Article Discussions by Author Discuss content posted by JayK Analysing a T-SQL Query RE: Analysing a T-SQL Query
Igor Micev
SSC-Dedicated
Points: 33109
More actions
March 21, 2012 at 12:25 pm
#1462364
Useful question, thank you
The following query with same structure as those in the question produces 0 joins
SELECT *
FROM QOTD
where qotdid = 1
because of "QOTD" which is clustered index
Igor Micev,My blog: www.igormicev.com