|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 20th, 2005, 11:44 PM
|
|||
|
|||
|
Update query taking long time to complete
There is a specific update query in our application which is taking long time to complete. The cost of the update query is very less. But it becomes fast as soon as we analyze the schema. Please let us know what has to be done regarding this problem. Also the schema has been analyzed the day before and ideally the update should have been fast but we had to repeat that procedure again. Please let us know what should be done to avoid this.
|
|
#2
February 21st, 2005, 10:06 AM
|
|||
|
|||
|
1. Make sure that there are indexes and you use them correctly.
2. Switch to rule based optimization - add a hint= UPDATE /*+ RULE */ ..... Cost based optimizers use statistics from ANALYZE TABLE COMPUTE STATISTICS. If the stats are way off, the optimizer will make bad choices.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Update query taking long time to complete |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
