Creating an XML File to Optimize Performance

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 >