• You can but I would only advise this in exceptional circumstances like you are not in a position to updates stats on a very, very large table or in a high tps environment. In a sense "dont try this at home" unless under supervision of an adult or an experienced dba.

    Adding WITH(INDEX=idx_i_am_an_index) just after the table name or alias.

    Another alternative is adding OPTION(FORCE ORDER) enforces the join order of the query given.