Question

2
Replies
371
Views
Hareen.Yadlapalli Member since 2011 17 posts
Incessant Technologies Pvt Ltd.
Posted: 4 years ago
Last activity: 4 years 4 months ago
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:

CREATENONCLUSTEREDINDEX [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:

CREATENONCLUSTEREDINDEX [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
Share this page LinkedIn