Order by with latestdate

SQL++
1

Hi All,

I would like to get the data between dates and sort by latestupdated timestamp … but the index is not working…

create index idx_date on student (joiningdate, lastUpdateTimestamp desc) where type = “student”;

select * from student where joiningdate BETWEEN “2019-01-29” AND “2020-02-29” where type = “student” order by lastUpdateTimestamp desc

The above query is taking 1 minute … could any one help.