Creating an optimization profile

An optimization profile is an XML document that contains optimization guidelines for one or more Data Manipulation Language (DML) statements.

About this task

Because an optimization profile can contain many combinations of guidelines, the following information specifies only those steps that are common to creating any optimization profile.


To create an optimization profile:

  1. Launch an XML editor. If possible, use one that has schema validation capability. The optimizer does not perform XML validation. An optimization profile must be valid according to the current optimization profile schema.
  2. Create an XML document by using a name that makes sense to you. You might want to give it a name that describes the scope of statements to which it applies. For example: inventory_db.xml
  3. Add the XML declaration to the document. If you do not specify an encoding format, UTF-8 is assumed. Save the document with UTF-16 encoding, if possible. The data server is more efficient when processing this encoding.
       <?xml version="1.0" encoding="UTF-16"?>
  4. Add an optimization profile section to the document.
  5. Within the OPTPROFILE element, create global or statement-level optimization guidelines, as appropriate, and save the file.

What to do next

After you have the XML document created, configure the data server to use the optimization profile by inserting the optimization profile into the SYSTOOLS.OPT_PROFILE table.