Subject | Update is Slow |
---|---|
Author | goonct |
Post date | 2003-06-05T08:41:40Z |
Hi,
When I issued the below sql query:
update HistCurr set IndiInitialized = 1
It took 6-7 minutes to complete the update. This table only consists
of 5000 rows.
Do you know how to improve the performance ?
regards, Chooi-Ting
When I issued the below sql query:
update HistCurr set IndiInitialized = 1
It took 6-7 minutes to complete the update. This table only consists
of 5000 rows.
Do you know how to improve the performance ?
regards, Chooi-Ting