Indexing and Forced Parameterization
Indexing and Forced Parameterization
Comments
-
We are hosting our Decisions Database in Azure, which has provided some highly recommended performance improvements using Indexing and Forced Parameterization.
Can you pleases advise if it is safe and advisable to run these recommendations?
[i]edited by kshitij@decisions.com on 12/24/2019[/i] -
Setting Indexes should be just fine. We often tune databases with customers by setting up some Selective Indexes.
Im not certain about the impact of the Forced Parameterization, but the Indexes are totally fine.
-
Thanks!
We’ll set the Indexes for now and do more research on the Paramaterization suggestion.
Howdy, Stranger!
Categories
- 4.3K All Categories
- 73 General
- 11 Training
- 206 Installation / Setup
- 1.1K Flows
- 109 Rules
- 268 Administration
- 212 Portal
- 496 General Q & A
- 709 Forms
- 340 Reports
- 3 Designer Extensions
- 48 Example Flows
- 56 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 184 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 69 Repository
- 229 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 57 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions