select * from content WHERE _type=‘Book’ and (userId = ‘cjklccr2x00540a44c6ifja3y’
OR ANY uid IN sharedElessonUserIDs SATISFIES uid =‘cjklccr2x00540a44c6ifja3y’ END) and type = “” and active = true
For the above query the INDEX used is like
sharedElessonUserIDs end))) WHERE (
_type = “Book”)
After using indexing it is taking arround 20 sec to execute.
Do I have to modified something in the Index??.. so that the query will execute with in miliseconds.