Home » RDBMS Server » Performance Tuning » Using of NO_INDEX hint with INSERT statement
Using of NO_INDEX hint with INSERT statement [message #65471] Wed, 29 September 2004 22:26 Go to next message
Baps
Messages: 5
Registered: September 2004
Junior Member
While inserting data, some tables are getting locked for a significant duration. I think this is for over indexing on those tables. If I use NO_INDEX hint with INSERT statement, whether the locking contention would be improved. Thanks in advance.

 

Report message to a moderator

Re: Using of NO_INDEX hint with INSERT statement [message #65472 is a reply to message #65471] Wed, 29 September 2004 22:44 Go to previous message
Deepak Panda
Messages: 24
Registered: May 2004
Junior Member
Try disabling all the foreign key constraints, and later enable them.

Hope this will make your instertions a bit faster.

Report message to a moderator

Previous Topic: LONG RAW performance problem
Next Topic: PE6650 and disk configuration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 14:10:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.