showplan
nounEtymology From show + plan.
1
Computing, Databases, Engineering, Mathematics, Natural sciences, Physical sciences, Sciences A text or graphical summary of how the system plans to optimize the execution of a query.
- 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.2002, Mark Spenik, Orryn Sledge, Microsoft SQL Server 2000 DBA Survival Guide, page 526: