Show TOC

Procedure documentationCreating an XML File to Optimize Performance Locate this document in the navigation structure

Procedure

  1. Create an XML file and enter values for the appropriate XML tags.

    Example Example

    • To create, delete, and update indices, use the syntax below:

      <?xml version="1.0" encoding="utf-8" ?><Model name = "com.sap.demo.servicecomp.dataobject"><Indexes version="1.0"><class DOName="BUSINESSPARTNER" DONodeName="BPADDRESS"><Index IndexName="Index1" ChangeType="CREATE" unique="y"><iattr attrname="SYNCKEY"/><iattr attrname="PARTNERID"/></Index><Index IndexName="Index2" ChangeType="DROP" unique="y"/></class><class DOName="PARTNER" DONodeName="PARTNER_DETAILS">< Index IndexName="Index3" ChangeType="ALTER" unique="y"><iattr attrname="PARTNERID" /><iattr attrname=”PARTNER_NAME” /></Index></class></Indexes></Model>

    • To set database parameters, use the syntax below:

      <?xml version="1.0" encoding="utf-8" ?><DBParams><Param Name = “CacheSize” Value =”1024” RestartRequired=”Yes”></Param></DBParams>

    • To update statistics of the data object, nodes, and corresponding attributes, use the syntax below:

      <?xml version="1.0" encoding="utf-8" ?><DBStats><Model name="com.sap.demo.servicecomp.dataobject" ><Command name="UPDATE STATISTICS" doname="PARTNER" nodename="PARTNER_DETAILS" nodeattribute="PARTNER_NAME"/><Command name="UPDATE STATISTICS" doname="PARTNER nodename="PARTNER_DETAILS "/><Command name="UPDATE STATISTICS" doname="*"/></Model></DBStats >

    End of the example.
  2. Save the XML file.