Planon is used across a wide variety of customer-specific configurations and environments. From a database perspective, this means that the indexes required for optimal performance can differ significantly from one customer to another. Standard indexes that are configured during development may work well for some customers, while being less effective — or even counterproductive — for others.

Modern database servers can analyze query patterns and provide recommendations about which indexes are missing or redundant for a given environment. The Index Advisor TSI brings this intelligence into Planon by presenting relevant database index recommendations and showing which ones have been applied automatically to optimize performance for your specific environment.

Index Advisor is available exclusively as a Cloud feature. Because the functionality relies on database-level advisor capabilities that are managed as part of the Planon Cloud infrastructure, it is not available for on-premises installations.

Unlike standard business objects where changes originate in Planon and are propagated to the database, Index Advisor works in the opposite direction. Data originates from the database server and is reflected in Planon for informational purposes.

Planon periodically collects index recommendations from the database server. Recommendations that are deemed useful for your environment are shown in Index Advisor. A scheduled database job then attempts to apply these recommendations automatically, so no manual action is required.

Because changes do not originate in Planon, the following applies:

Index Advisor contains one level: BO Advice, which shows the database index recommendations that are relevant for your environment and can be applied automatically.

In the element list, each entry shows the business object and the recommendation. You can use the standard filter on Business object definition to narrow down the list.

Each index recommendation progresses through the following statuses: