improve the performance of index all for large dataset

Do not use skip limit, because its performance will drop for large datase