I have perform indexing on date column in many of my sql tables. My question while applying indexing date we have sort option as well to perform the indexing in descending or ascending order.
Please suggest while index the date column sort should be asc or desc.
If I sort desc will it increase performance because 98 percent time user is retreiving current data.