SQL is ignoring my index hint and using a clustered index.
Part of this gets information from a table where an index hint has been included.
Looking at the execution plan, SQL is ignoring the index hint and choosing to use the clustered index on the table, which is not efficient.
The fragmentation on the table <=8%. I have come across this before and rebuilding the indexes does work, but this will require downtime as the table is in constant use and SQL is not enterpirse edition. Is there any way to force SQL to use the index hint provided to it?