The order_lastmod_idex index in the dcspp_order table can cause performance degradation in OLTP environments. If your environment is experiencing performance issues, you can drop this index.

Note that the lastModifiedDate property, on which this index is based, is used in queries accessed by the atg.commerce.order.OrderQueries class, as well as in the CommercProfileTools.
loadShippingCarts methods. For information on the OrderQueries class, refer to the Business Layer Classes section of the Commerce Programming Guide. For information on the CommerceProfileTool, refer to the Profile Tools and Property Manager Extension section of the Commerce Programming Guide.

Additionally, this index is used when performing manual index requests of orders when creating full text order searches in the Dynamo Server Admin. For information on full text searches and orders, refer to the Configuring Order and Profile Search section of the Commerce Service Center Installation and Programming Guide.