Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Non-Cluster Index issue Expand / Collapse
Author
Message
Posted Tuesday, August 10, 2010 6:44 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Tuesday, August 10, 2010 6:52 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 3:23 AM
Points: 403, Visits: 287
Can you mention what type of non-clustered index you are creating....

How many indexes are there in that table...
Post #966635
Posted Tuesday, August 10, 2010 6:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 5,424, Visits: 10,083
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 »

Add to briefcase

Permissions Expand / Collapse