i am working on a table which currently contains 100000 records, and will be more and more in future, now my clients want the LATEST TOP 10 RECORDS...
using top clause diminishes the performance, and as this is the mobile application, performance is the only concern, so is there any alternate and the best way for getting Latest Top 10 records also the order by could result in loss of performance
does these two have any best performance alternative..
I think the best option is use another table where you have the latest 10 records.
So, when your app insert a record, it has to record it in both tables... The big one and the top 10 one. Or it is possible to do a trigger that do this work.