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.2K All Categories
- 68 General
- 11 Training
- 203 Installation / Setup
- 1.1K Flows
- 108 Rules
- 262 Administration
- 212 Portal
- 494 General Q & A
- 698 Forms
- 334 Reports
- 3 Designer Extensions
- 47 Example Flows
- 52 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 180 Pages
- 5 Process Mining
- New Features
- 179 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 80 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 92 Lunch And Learn Questions