"Order by " making the N1QL Query slow

[vsr1]

CREATE INDEX ix1c ON content(createdAt DESC, status, name,tags,url,_id) WHERE _type="UserAsset";
OR
CREATE INDEX ix1 ON content(createdAt DESC) WHERE _type="UserAsset";

SELECT _id,name,url,tags,status,createdAt
FROM content 
WHERE  _type="UserAsset" AND createdAt IS NOT MISSING
ORDER BY  createdAt DESC
LIMIT 10;