Hi i am trying to turn a table hint into a plan guide as i can not change 3rd party code.

table hint

select .........from table x with(INDEX (<index_NAME)

for plan guide i can not find an example of the sql i would need to use

@hint = N'OPTION....?

please could someone give me the correct syntax

Thanks