Single Index to cover different sort fields (both asc & desc)

SQL++
,
3

Hi @vsr1

I tried the below index, Query1 looks fine but Query 2,3,4 takes more time to get the results. Am I missing something? could you please give me an example of an index that suits my need, please?

CREATE INDEX idx_ImageSearch ON QA-ImageManagement(OriginalWidth,OriginalHeight) WHERE (Type = “Image”)