N1ql query is slow in join even indexes are created

SQL++
,
2

This is INNER JOIN try following (also provide HASH hint if needed)

SELECT c.customer_id, c.first_name, c.last_name, c.created_date, c.status,
       c.email, c.address, c.city, c.zip_code, c.state, c.contact,
       inv.referal_or_corp, inv.store_id
FROM st_data_bucket AS inv
JOIN st_initialization_hq AS c ON inv.cus_id = c.customer_id AND inv.type = "invoice"
WHERE c.type = "customer" AND inv.date BETWEEN "2022-08-01" AND "2022-08-31"

CREATE INDEX ix1 ON st_initialization_hq(customer_id,city,state,status,contact,zip_code,created_date,email,address,last_name,first_name) WHERE type = "customer";
CREATE INDEX ix2 ON st_data_bucket(date, cus_id, store_id,  referal_or_corp) WHERE type = "invoice";