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.4K All Categories
- 86 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 111 Rules
- 282 Administration
- 216 Portal
- 500 General Q & A
- 718 Forms
- 353 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
- 233 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 27 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions