Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlPlanInsights

Represents collection of SQL Plan Insights.

Properties

category

category: string

SQL Insight category. For example PLANS_USED, MOST_EXECUTED, BEST_PERFORMER, WORST_PERFORMER, MOST_CPU or MOST_IO.

text

text: string

SQL Plan Insight text. For example {@code Number of Plans Used}, {@code Most Executed Plan}, {@code Best Performing Plan}, {@code Worst Performing Plan}, {@code Plan With Most IO}, {@code Plan with Most CPU}

value

value: number

SQL execution plan hash value for a given insight. For example {@code Most Executed Plan} insight will have value as "3975467901" Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

getJsonObj