Non-Cluster Index issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Non-Cluster Index issue

Non-Cluster Index issue

Rate Topic

Display Mode

Topic Options

Author

Message

varshini

Posted Tuesday, August 10, 2010 6:44 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 23, 2012 3:03 PM
Points: 99, Visits: 107

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 ?????????

Post #966626

VENUGOPAL.RR

Posted Tuesday, August 10, 2010 6:52 AM

Old Hand

Group: General Forum Members
Last Login: Saturday, April 13, 2013 10:02 AM
Points: 398, Visits: 277

Can you mention what type of non-clustered index you are creating....

How many indexes are there in that table...

Post #966635

John Mitchell-245523

Posted Tuesday, August 10, 2010 6:55 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 4,428, Visits: 7,196

We can't really help you without table and index DDL, sample data and the query for the report.

John

Post #966645

« Prev Topic | Next Topic »

Permissions