Hi, I am using SQL Server 2005 Std. Ed. I have a table with 30+ Lakhs records. I have the index on this table. When I write the SELECT COUNT(*) FROM tblTableName, it tooks around 30 to 40 sec to retrieve the Count. Its too slow. I am using ASP.Net + ADO.Net as front end to show the reports. If this query takes this much of time then my application need to wait around 1 min. to show the output. Now i want to know.. How to reduce the time to take the total records from the huge table. Please answer me as soon as possible. Thanks in advance. Ganesh.