Optional
allIf set to true, all possible execution plans will be returned as the
plans
property. Otherwise only the optimal execution plan will be
returned as the plan
property.
Default: false
Optional
maxMaximum number of plans that the optimizer is allowed to generate. Setting this to a low value limits the amount of work the optimizer does.
Optional
optimizer?: { An object with a rules
property specifying a list of optimizer rules to
be included or excluded by the optimizer for this query. Prefix a rule
name with +
to include it, or -
to exclude it. The name all
acts as
an alias matching all optimizer rules.
Options for explaining a query.
See Database#explain.