Unfortunately he wants it backwards - DESC. So it does need sorting if you read it with FTS.
(again I would question NEED . . . . see my post on page one)
Printable View
Unfortunately he wants it backwards - DESC. So it does need sorting if you read it with FTS.
(again I would question NEED . . . . see my post on page one)
Desc, Asc, either way an FTS will require a sort -- I don't know that there is any saving in having the table physically sorted in the desired order. Might be worth testing.