I have tried below two queries to return content fragments below certain dam path.
On explain query tool I see queries "no indexes used".
query1:
/jcr:root/content/dam/test/footnote-1//element(*, dam:AssetContent)
query2:
/jcr:root/content/dam/test/footnote-1//element(*, dam:Asset)
c...