OraFAQ Forum: Performance Tuning » Tuning update statement

Home » RDBMS Server » Performance Tuning » Tuning update statement

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

Tuning update statement [message #236581]

Thu, 10 May 2007 05:17

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

Report message to a moderator

Re: Tuning update statement [message #236585 is a reply to message #236581]

Thu, 10 May 2007 05:28

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

Report message to a moderator

Re: Tuning update statement [message #236598 is a reply to message #236585]

Thu, 10 May 2007 05:55

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 .

Report message to a moderator

Re: Tuning update statement [message #236622 is a reply to message #236598]

Thu, 10 May 2007 07:22

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 09:20:24 CDT 2024