August 10, 2010 at 6:44 am
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 ?????????
August 10, 2010 at 6:52 am
Can you mention what type of non-clustered index you are creating....
How many indexes are there in that table...
August 10, 2010 at 6:55 am
We can't really help you without table and index DDL, sample data and the query for the report.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply