Statement Best Preparation Time



Snapshot Level
Dynamic SQL


Logical Data Grouping
dynsql


Monitor Switch
Basic


Resettable


No


 


Element Name
Element Type



prep_time_best
water mark

 

Description:  The shortest amount of time that was required to prepare a specific SQL statement.

Usage:  Use this value in conjunction with "Statement Worst Preparation Time" to identify SQL statements that are expensive to compile.