Custom index validation
Hi,
I’m trying to optimize oak indexes in a Clou. We have a few custom queries that are running very slow, and after checking explain plans, it looks like they’re falling back to traversal. I know AEMaaCS doesn’t allow direct CRXDE changes, so indexes need to be managed via code deployments.
What’s the best way to properly define and deploy a custom oak:index in Cloud Service, and how can I safely test changes before pushing them through Cloud Manager? Also, are there tools or recommended steps to validate whether the new index is actually being used by queries?
Thanks!