using index.....

[k_sekhar_rao]

hi all,

As far i know,using index in an select query is allowed. Can we use index in an update query, if yes can anyone tell me the syntax how to use it?

Thanks in advance,
sekhar

[skhanal]

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.