|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 9th, 2005, 03:14 AM
|
|||
|
|||
Update Query takes long time to complete
In Oracle,i hav two tables.both are having more than 10 lac records.i want to update some fields in a table with the another table.i wrote a pl/sql block with cursor and updating the table.but it takes nearly 1 hr to update. is there any way to update fast ?.......Pls help.
|
|
#2
February 9th, 2005, 10:29 AM
|
|||
|
|||
|
You need to learn about using indexes to speed up what you are doing.
The table that is getting updated needs indexes on the search fields. The table that is supplying the data needs index(es) on the filed that you are using to search on. Either add indexes or change your query to use indexed fields. Investigate EXPLAIN PLAN as well.
|
|
#3
February 12th, 2005, 04:22 AM
|
|||
|
|||
It Works !........
After adding indexes on necessary fields. Thank u very much............
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Update Query takes 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
