Question

2
Replies
377
Views
Close popover
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
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