SQL UPDATE — Measure execution timeIT technician command center
● ITSign inMembers
Database · SQL and Database Administration

SQL UPDATE — Measure execution time

Measure the command execution time. Base task: Update matching rows.

Copy-ready commandSQL UPDATE — Measure execution time
time UPDATE users SET enabled = 0 WHERE id = 42
Production warning

INSERT, UPDATE, DELETE, ALTER, and restore operations can modify or remove data.

Requirements and permissions

Requirements
Appropriate database client and connection
Permissions
Database privileges vary
Last reviewed
2026-08-01

Examples

Measure execution time

Measure the command execution time.

time UPDATE users SET enabled = 0 WHERE id = 42

Common errors

Command or option not supported

Confirm the installed platform version supports the base command and the added output or wrapper option.

Access denied or insufficient privileges

Run with the administrative role or delegated permission required by the underlying command.