Indexing for performance

Hello everyone,
I have this N1QL script written and I it performs very slow on big amounts of documents, I am looking into indexing as im still fairly fresh with couchbase. My query is: UPDATE myBucket AS d
SET d.parentClass =(FIRST p.id FOR p IN
(SELECT d1.parentId , meta(d1).id, d1.locale, d1.language
FROM myBucket d1
WHERE d1._class = "secondaryClass”
AND d1.hasChildren = true)
WHEN d.parentId = p.parentId AND p.locale = d.locale AND p.language = d.language END)
WHERE d._class =“secondaryClass”
AND d.format IS NOT MISSING AND d. parentClass IS MISSING and parentId like ‘par%’;

I have these indexes below:
CREATE INDEX adv_class_format ON myBucket(_class,format)
CREATE INDEX adv_parentId ON myBucket(parentId)

But im pretty sure im missing some indexes as the query is too slow, any ideas for indexes that would speed this up?

UPDATE myBucket AS d
SET d.parentClass = (FIRST p.id FOR p IN (SELECT d1.parentId , meta(d1).id, d1.locale, d1.language
                                          FROM myBucket d1
                                          WHERE d1._class = "secondaryClass" AND d1.hasChildren = true
                                                AND d1.parentId LIKE "par%"`
                                          )
                     WHEN d.parentId = p.parentId AND p.locale = d.locale AND p.language = d.language END)
WHERE d._class ="secondaryClass"
AND d.format IS NOT MISSING AND d.parentClass IS MISSING AND d.parentId LIKE "par%";


CREATE INDEX ix1 ON myBucket(parentId) WHERE _class ="secondaryClass" AND parentClass IS MISSING ;
CREATE INDEX ix2 ON myBucket(hasChildren, parentId, locale, language) WHERE _class ="secondaryClass";


CB 6.5
MERGE INTO myBucket AS m USING (SELECT d1.parentId, meta(d1).id, d1.locale, d1.language
                                FROM myBucket d1
                                WHERE d1._class = "secondaryClass"
                                      AND d1.hasChildren = true
                                      AND d1.parentId LIKE "par%" ) AS s
ON m.parentId = s.parentId AND m.locale = s.locale AND m.language = s.language
WHEN MATCHED THEN m.parentClass = s.id WHERE m.format IS NOT MISSING AND m.parentClass IS MISSING;