Home » RDBMS Server » Performance Tuning » Tuning update statement
Tuning update statement [message #236581] Thu, 10 May 2007 05:17 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am a novice with respect to performance tuning

I wanna tune an update statement which updates records of a table containing ard 100 records .The table is not partitioned .

Will using cache optimizer hint help me in tuning the same?

Suggest me some alternative which can increase the performance
Re: Tuning update statement [message #236585 is a reply to message #236581] Thu, 10 May 2007 05:28 Go to previous messageGo to next message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Are you facing any perfromance issues with the update , why do You feel that updating a 10o records will need tuning , have you tested anything?

Thanks
Re: Tuning update statement [message #236598 is a reply to message #236585] Thu, 10 May 2007 05:55 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
The query is run when a patch is applied to the database and it is run more than 1000 times , so even if there is a small performance improvement it will be very useful .
Re: Tuning update statement [message #236622 is a reply to message #236598] Thu, 10 May 2007 07:22 Go to previous message
sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM
Member
Ok ,

Please can you elaborate about about the update script ?

Is this a pl/sql proc or a sql script

Can you attach your script please

Thanks

Previous Topic: indexes difference as table columns
Next Topic: Regarding partitions
Goto Forum:
  


Current Time: Sun Dec 11 08:32:21 CST 2016

Total time taken to generate the page: 0.04429 seconds