select *
from bucket as doc
where doc.name = "value " where doc.type = “group”
order by doc.lastModified desc
create index ix1ON `bucket` (name, lastModified DESC ) where type = “group”;
select *
from bucket as doc
where doc.name = "value " where doc.type = “group”
order by doc.lastModified desc
create index ix1ON `bucket` (name, lastModified DESC ) where type = “group”;