Database Query Plan

[Deleted User]

Is there a database query plan that Decisions stores somewhere?

[Deleted User]

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