Database Query Plan

Decisions does not automatically create query plans for its SQL executions, so we do not store it. However, databases have commands available to view the execution plan of a query. For instance, PostgreSQL can use the EXPLAIN statement.

PostgreSQL:

EXPLAIN Select * From element_registration

My current database requires me to use SET SHOWPLAN_ALL before and after the query. Within a Decisions Project, please choose the three dots on a folder to choose Query Editor. Here you can run the following query as an example

SQL Server:

SET SHOWPLAN_ALL ON;
GO
Select * From element_registration
SET SHOWPLAN_ALL OFF;
GO