Question d’entretien chez Muthoot FinCorp ONE

Window function, optimize query. How to handle large data set?