• 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