Miscellaneous SQL statements These are particular SQL statements supported in the static SQL syntax. SET EXPLAIN Turns on/off SQL report of the optimizer plan. UPDATE STATISTICS Updates the statistics for all or for the specified table in the database.