Hello,
I have 2 bucket - AccountFirstId(38,323,647 documents ) / SubscriberInfo(43,874,195 documents ).
It looks like this:
CREATE INDEX IDVIEW_index1 ON AccountFirstId(FIRSTID, CONTR_COMPONENT_ID) USING GSI;
{
“AccountFirstId”: {
“CONTRACT_ROLE_ID”: “102243729531306002”,
“CONTR_COMPONENT_ID”: “101043729531303902”,
“FIRSTID”: “A123456789”,
}
}
CREATE INDEX IDVIEW_index2 ON SubscriberInfo(ACT_CONTR_COMPONENT_ID, CONTR_COMPONENT_ID) USING GSI;
{
“SubscriberInfo”: {
“ACCOUNT_ID”: “413549014”,
“ACT_CONTR_COMPONENT_ID”: “108243565596500004”,
“ACT_PARTY_ID”: “103943560327366403”,
“ADMIN_FLD_NM_TP_CD”: “120”,
“CONTRACT_ID”: “104743565596499504”,
“CONTR_COMPONENT_ID”: “101043565596640101”,
}
}
I executed what I thought was a simple N1QL Query in Couchbase version 5.5.2
select INFO.*
from AccountFirstId AFIRSTID
JOIN SubscriberInfo INFO ON (INFO.ACT_CONTR_COMPONENT_ID = AFIRSTID.CONTR_COMPONENT_ID)
where AFIRSTID.FIRSTID =“A123456789”
I have created index but the result take about 5 minutes.(Total data is about 320,151 documents.)
i really don’t understand why got this problem because this really a simple usecase?
does someone can help?
