hi,
There are a total of 15,304 documents on the bucket. I query through these documents, but they respond very slowly.
I added indexes but nothing changed.
query:
select id from PiriWiki USE INDEX (ademtest USING GSI)
where type='Timeline’
and templateId='template-timeline’
and pageId = ‘2016-07-15-21-00’ and
isApproved and languageId=‘tr’
index
CREATE INDEX tes1 ON PiriWiki(abv) WHERE (((((type = “Timeline”) and (templateId = “template-timeline”)) and (pageId = “2016-07-15-21-00”)) and isApproved) and (languageId = “tr”))