Is Sorting required?

I’ve a grid which will have thousands of records. If I enable sorting, would that impact any performance ?

Quite unlikely, but it depends on your DataProvider. It should be easy to test it.

    public Page<CustomerEntity> list(Pageable pageable) {
        return repository.findAll(pageable);
    }```

This is my data provider

and the PageRequest is // Create PageRequest with sorting PageRequest pageRequest = PageRequest.of( query.getPage(), query.getPageSize(), Sort.by(springSortOrders) );

https://www.sqlshack.com/sql-server-order-by-performance-tips/