Description
On upgrade to 7.6 or when we have new provisioned cluster, sequential scan should be disabled in Capella provisioned profile. They can be disabled in the query settings n1ql feature control setting.
From Kamini Jagtiani
We can turn sequential scans off by ”OR”ing the current n1ql_feat_ctrl with 0x0000004000 (Decimal: 16,384).I believe the current value for n1ql_feat_ctrl is 4c(Decimal:76).
So the new value should be 0x404c(Decimal: 16460) to turn it off.
It can be done via UI(N1QL Feature Controller under advanced query settings) or curl
curl -s -u Administrator:password http://localhost:8091/settings/querySettings -d 'queryN1QLFeatCtrl=16460'
|
This will disable sequential scan at the cluster level for all nodes.
Attachments
Issue Links
- causes
-
MB-60193 Query service does not start when cluster is in provisioned mode
- Closed