| Neeraj |
Posted: Oct 05, 2007 06:06:07 AM |
Total Post: 228
Joined: Jan, 2007
|
hi,
in my server many proces r being processed, but one of them proces which r updating a table getting slow but running.
tell y it happened & how can i make it speed up again.
its a taking long time to updating a particular table.other proces running well.size is enough.
the updation is being done by a proc.
thxs
|
|
|
 Raj |
| Posted: Oct 10, 2007 09:45:27 AM |  |
|
Total Post: 9
Joined: Apr, 2007
|
Hi
Is there any where condition in where clause of your update?
If yes check whether indexes are present?
reagrds
Raj
|
|
|
|
|
| Neeraj |
| Posted: Oct 11, 2007 01:34:39 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
i hav checked index is present.
|
|
|
|
|
| chandu |
| Posted: Oct 24, 2007 05:23:30 AM | |
|
Total Post: 1
Joined: Oct, 2007
|
|
|
|
|
| Manu |
| Posted: Nov 19, 2007 12:33:25 AM | |
|
Total Post: 11
Joined: May, 2006
|
Take the explain plan of the update statement and ensure whether it is scaning the index.
|
|
|
|
|
| Neeraj |
| Posted: Nov 19, 2007 02:28:26 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
how to take the explain plan ?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
