Question

2
Replies
380
Views
Hareen Ganesh Yadlapalli (Hareen.Yadlapalli)
Incessant Technologies Pvt Ltd.

Incessant Technologies Pvt Ltd.
AU
Hareen.Yadlapalli Member since 2011 17 posts
Incessant Technologies Pvt Ltd.
Posted: April 7, 2016
Last activity: April 27, 2016
Posted: 7 Apr 2016 21:32 EDT
Last activity: 27 Apr 2016 9:43 EDT
Closed

Can the OOTB index index_key_purp on the table pc_index_workparty be updated?

We are seeing some performance issues with queries that are being run on pc_index_workpary and updating the OOTB index index_key_purp helped in improving the performance of these queries.

New Index:

CREATE NONCLUSTERED INDEX [index_key_purp] ON [dbo].[pc_index_workparty]

(

       [pxInsIndexedKey] ASC,

       [pxIndexPurpose] ASC,

       [(pxObjClass)],

       [(pxPartyRole)],

       [(pyPartyIdentifier)]

)

Would like to know if it is safe to update (drop and recreate) the OOTB index with the same name but new definition or create a new index altogether with the new defintion, can some one assist please?

We did an update (drop and recreate) the existing index as the existing index also would do the similar thing


Existing Index:

CREATE NONCLUSTERED INDEX [index_key_purp] ON [dbo].[pc_index_workparty]

(

       [pxInsIndexedKey] ASC,

       [pxIndexPurpose] ASC,

       [(pxObjClass)],

       [(pxPartyRole)],

       [(pyPartyIdentifier)]

)


Message was edited by: Lochan to add Category

System Administration Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.