English edit

Etymology edit

show +‎ plan

Noun edit

showplan (plural showplans)

  1. (databases) A text or graphical summary of how the system plans to optimize the execution of a query.
    • 2002, Mark Spenik, Orryn Sledge, Microsoft SQL Server 2000 DBA Survival Guide, page 526:
      The showplan provides insight about how SQL Server is going to process a SQL statement. If you know what to look for in a showplan, the information it provides can be useful for tuning queries.