Frex, that limit is there for a reason. Once you exceed about 8 indices, performance increasingly suffers, especially on submits.
Rick -----Original Message----- From: Frex Popo <frexp...@yahoo.fr> Date: Thu, 4 Jun 2009 18:39:20 To: <arslist@ARSLIST.ORG> Subject: Re : Non clustered indices (ITSM 7.3) Reason I am asking is that I think it's better to create the index through the Admin Client so that the server is aware of it rather than having to create the index at the DB level.. But if it comes to having to create it at the DB level I think I would opt for the latter since having an index is better than not having it at all :) --- En date de : Jeu 4.6.09, Frex Popo <frexp...@yahoo.fr> a écrit : De: Frex Popo <frexp...@yahoo.fr> Objet: Non clustered indices (ITSM 7.3) À: arslist@ARSLIST.ORG Date: Jeudi 4 Juin 2009, 12h26 Hello everyone, Found a number of join forms using a particular column in the join criteria. This column did not look it was indexed on the base form (i.e. HPD:Help Desk), so thought let's create one. When I tried to do so I got a SQL error: No se pudo crear índice no agrupado 'I1035_904003986_1' porque supera el máximo de 249 permitido por tabla o vista. (SQL Server 1910) (ARERR 552). Failure during SQL operation to the database : 904003986 (ARWARN 552). This simply means that the SQL server could not create the nonclustered index as it is beyond the maximum allowed. The form has 13 indexes. As a test I removed an existing non clustered index and create the new one and it works just fine, but of course I want to keep all the existing ones and be able to create the new one. I checked the table definition in the SQL Enterprise client by running sp_helpindex and got a list of some 250 entries. Now, I don't have a non customised version of this form nor do I have another environment to check if this is all created by the remedy server, hence the question, does anyone have all these indices defined on the Help Desk form in their ITSM 7.0 installation? I am using ARS 7.1 patch 4 / ITSM 7.3 / SQL server 2005. Here is part of the 250 entries. index_name,index_description,index_keys I1035_1000000019_1,nonclustered located on PRIMARY,C1000000019, C1000000018 I1035_1000000063_1,nonclustered located on PRIMARY,C1000000063, C1000000064, C1000000065 I1035_1000000079_1,nonclustered located on PRIMARY,C1000000079 I1035_1000000080_1,nonclustered located on PRIMARY,C1000000080 I1035_1000000161_1,nonclustered, unique located on PRIMARY,C1000000161 I1035_1000000427_1,nonclustered located on PRIMARY,C1000000427 I1035_1000000869_1,nonclustered located on PRIMARY,C1000000869 I1035_1000000875_1,nonclustered located on PRIMARY,C1000000875 I1035_179_1,nonclustered, unique located on PRIMARY,C179 I1035_200000003_1,nonclustered located on PRIMARY,C200000003, C200000004, C200000005 I1035_240001002_1,nonclustered located on PRIMARY,C240001002 I1035_4_1,nonclustered located on PRIMARY,C4 I1035_7_1,nonclustered located on PRIMARY,C7 missing_index_100016,nonclustered located on PRIMARY,C1000000079, C1000003009, C7 missing_index_100040,nonclustered located on PRIMARY,C1000000014, C1000000251, C1000000296, C1000000082, C1000000217 missing_index_100058,nonclustered located on PRIMARY,C1000000014, C1000000251, C1000000079, C1000000082, C1000000217 missing_index_100062,nonclustered located on PRIMARY,C1000000014, C1000000079, C1000000217, C1000000251, C1000000082 missing_index_100064,nonclustered located on PRIMARY,C1000000014, C1000000217, C1000000251, C1000000082 missing_index_100089,nonclustered located on PRIMARY,C1000000079, C7 . . . . missing_index_99846,nonclustered located on PRIMARY,C1000000099, C1000000251, C7 missing_index_99878,nonclustered located on PRIMARY,C1000000014, C1000000251, C1000000082 missing_index_99880,nonclustered located on PRIMARY,C1000000014, C1000000251, C1000000082, C1000000217 missing_index_99882,nonclustered located on PRIMARY,C1000000014, C1000000079, C1000000251, C1000000296, C1000000572, C1000000082, C1000000217 missing_index_99929,nonclustered located on PRIMARY,C7 PK__T1035__4032018A,clustered, unique, primary key located on PRIMARY,C1 Regards frex _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"