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