Home >  Term: optimized SQL text
optimized SQL text

SQL text, produced by the Explain facility, that is based on the query actually used by the optimizer to choose the access plan. This query is supplemented and rewritten by the various components of the SQL compiler during statement compilation. The text is reconstructed from its internal representation and differs from the original SQL text. The optimized statement produces the same result as the original statement.

0 0

Creator

  • Peteh
  •  (V.I.P) 14225 points
  • 100% positive feedback
© 2024 CSOFT International, Ltd.