Review Jurisdiction tables indexes

Fixed in

EPiServer.Commerce 13.13.0

Created

Nov 12, 2019

Updated

Dec 20, 2019

Area

Core

State

Closed, Fixed and tested


Description

Jurisdiction tables might be missing some indexes to help with performance.

Reported from https://world.episerver.com/forum/developer-forum/Feature-requests/Thread-Container/2019/11/azure-db-performance-recommendations---jurisdiction-table-indexes/

To address this, we reviewed the indexed items in the related db tables. Based on customer feedback, a new index was added.