Thank you @Saravanan_Dharmaraj for your response. I have already defined the index for this query and still getting the same warning.The response from query performance: Parsing JCR-SQL2 statement: explain select [jcr:path], [jcr:score], * from [cq:Workflow] as a where [status] = 'RUNNING' and isdes...