ALTER TABLEtable‑nameSET {OPTIMISTIC | PESSIMISTIC}
Access requirements
Database user
Usage
Use the ALTER TABLE ... SET OPTIMISTIC or SET PESSIMISTIC statement to set disk-based tables (D-tables) to optimistic or pessimistic. By default, all D-tables are optimistic. M-tables are always pessimistic. A database-wide default for D-tables can be set with the solid.ini parameter General.Pessimistic, see General section.