[Optimization] Currently the limit needed to sort all records.

[astor-oss]

1. Currently the select * from table1 limit 10 will sort all records, then the time cost is very high
2. We need optimize the SQL plan to disable sort, and query the minimal partition, and fetch the records