-
using index.....
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|