OraFAQ Forum: SQL & PL/SQL » Force an index in an update statement

Home » SQL & PL/SQL » SQL & PL/SQL » Force an index in an update statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Force an index in an update statement [message #33145]

Thu, 23 September 2004 02:42

Milly
Messages: 72
Registered: March 2004

Member

Hi all!

I have to use an index in my update statement, where have I to set the clause?

UPdate table

set x = ....

WHERE....

�

thank!

Report message to a moderator

Re: Force an index in an update statement [message #33152 is a reply to message #33145]

Thu, 23 September 2004 04:10

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

your updated column is having index if that is the case implicitly it will use index in that update statement or u can use hints in update statement

eg: update /*+ index(index_name) */ tablename set
col_name = value......

Regards

Dilip

Report message to a moderator

Previous Topic:	plz solve this query
Next Topic:	Oracle And Excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 13 22:07:46 CDT 2026