Cover index for union and order by condition

query
index

#1

Hi,

I have query like this:

Can you suggest are there anyway to create a cover index for this to speed up fetching time ?

Regards,


#2

CREATE INDEX news_type_cate_all2_idx ON News(newsType,cate,dateTimeCreated DESC,parent_cate, alias,content) WHERE (type = “News”)

Checkout Designing Index For Query In Couchbase N1QL in https://blog.couchbase.com/wp-content/uploads/2017/10/N1QL-A-Practical-Guide-2nd-Edition.pdf