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.
methods. For information on the
loadShippingCartsOrderQueries
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.