• I've found it's general advisable to avoid index hints almost always.

    Indexes change, data changes, you might be forcing something to run in a way that used to be appropriate when you carried out the initial data load, but has become less and less useful over time as things have evolved.

    It's a special day indeed when I decide that an index hint is the BEST way to run a query.