I had some performance issue in the report so i created non-cluster index for that table. so i solve the performance issue the report.
Now i am facing the different issue because of the Non-Cluster index. While i am inserting records in the table its take too much time and some time the application itself shows time -out error. So i droped the Non-Cluster index... Now there is no time out issue in the application but in the report i got the performance issue ... what is the solution for that ?????????