showplan

From Wiktionary, the free dictionary
Jump to navigation Jump to search

English

[edit]

Etymology

[edit]

From 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.