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
- 64 General
- 11 Training
- 201 Installation / Setup
- 1.1K Flows
- 106 Rules
- 261 Administration
- 212 Portal
- 490 General Q & A
- 694 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 178 Pages
- 5 Process Mining
- New Features
- 178 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 78 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 76 Lunch And Learn Questions