i create two indexes on the same col
order by col
on the col in where condition and col in order by
but it's take 5 second and this not usefull for develepment team ,
if i create compound index it's will be batter and be informed that table contain data that inserted every one hours
i think in this suituaation the indexes is not usefull???