statement cache restore argument: Restore the SQL statement cache (SQL administration API)

Use the statement cache restore argument with the admin() or task() function to restore the statement cache.


>>-EXECUTE FUNCTION--+-admin-+--(--+-"statement cache restore"-+----->


statement cache restore is used to:
  • Lock the Statement Cache
  • Read each row from sysadmin: statement_cache table
  • Prepare the statement for the saved row so that statement will be inserted into the cache
    Note: If cache entry is Locked and has STMT_CACHE_QUERY_PLAN enabled, then it will be revived in its saved form.
    Note: If cache entry was Locked and had STMT_CACHE_QUERY_PLAN enabled when it was saved, then the text form of the query plan will be restored.
  • Unlock the Statement Cache

Copyright© 2020 HCL Technologies Limited