Change existing Index D365FO
As we all have a requirement in the past to perform the
changes in the existing indexes, and as we know the customization is not
allowed in the OOTB elements, so we couldn’t achieve this.
How we can achieve it?
In D365FO, we couldn’t delete or disable the existing index,
but there is one way to achieve this.
We can disable the index on SQL level by using the SQL
script even on prod.
Yes, you are reading correct, we can disable the index
and it will not enable again during package deployment, please only disable
the index not remove the index, otherwise, Microsoft classes will re-create the
index during deployment.
How you can disable the index?
public void disableIndex(str _tableName, str _indexName)
{
str sql;
Connection conn;
SqlStatementExecutePermission
permission;
;
sql= strFmt("ALTER INDEX %1 ON %2
DISABLE;", _ indexName, _tableName);
// sql = ‘delete
from custTable’;
permission = new SqlStatementExecutePermission(sql);
conn = new Connection();
permission = new SqlStatementExecutePermission(sql);
permission.assert();
conn.createStatement().executeUpdate(sql);
// the
permissions needs to be reverted back to original condition.
CodeAccessPermission::revertAssert();
}
Important
Before applying the index, please perform the analysis on your existing data, might possible
you can face the issue.
Thanks for sharing Valuable information.
ReplyDeleteMicrosoft d365 for finance and operations
D365 finance and operations online training
What has your government done to help save you from your financial instability? you strive to survive and yet you hear stories of how your leaders have become terror in your entities... is time to make a different. for will have made money, and we have also come to help you out from your long time of financial suffering. clearing of credit card is made available, software for hacking ATM machines, bank to bank hacking and transfer, change your school grade and become something useful in the society. we also have other form of services such as Facebook hack, whats-app hack, twitter hack, i cloud hack, tracking of smart phones, hacking CCTV, installation of software on desktop and PC, snap-chat hack, Skype hack, wire wire, bitcoin account hack, erase your criminal record and be free for ever. database hack and many more. e-mail: cyberhackingcompany@gmail.com for your genuine hacking services and we shock we your findings.
Delete