Kbase P24102: Why does the UPDATE STATISTICS command start a transaction?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/04/2003 |
|
Status: Unverified
GOAL:
Why does the UPDATE STATISTICS command start a transaction?
FACT(s) (Environment):
Progress 9.x
FIX:
The SQL92 engine starts a transaction when reading data (not just when writing data). The UPDATE STATISTICS command starts by reading data, consequently a transaction is started
FIX:
Starting with 9.1D, a transaction is started but all the data records are read "no lock" so there will be no effect on the database