Database Query Plan
Is there a database query plan that Decisions stores somewhere?
Comments
-
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
Howdy, Stranger!
Categories
- 4.4K All Categories
- 84 General
- 13 Training
- 210 Installation / Setup
- 1.2K Flows
- 111 Rules
- 272 Administration
- 214 Portal
- 498 General Q & A
- 714 Forms
- 349 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 188 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 70 Repository
- 230 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 26 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions