You can use table hint in FROM clause like
UPDATE ... WITH tablehint
SET ...
WHERE ...
or use query hint using OPTION clause as
UPDATE ..
SET ...
WHERE ... OPTION queryhint
Check books online.
Results 1 to 2 of 2
Thread: using index.....Threaded View
|
|
|