ok..can you just give me rough estimate how much time SQL to take to fetch 20 million records

Yes, that column is also indexed.

oops 🙂

any ways is there any fastest way to retirval the data from this table.

If I am fetching data for previous day then query is talking around 30 min.

Hi Koren,

Yes its 401415793 number of rows in that partition. As we are in TELECOM domain that table contain usage records for all subscribers.

I am using SQL Server Managment...