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.
Procedure
To create an optimization profile:
- 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.
- 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
- 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"?>
- Add an optimization profile section to the document.
<OPTPROFILE>
</OPTPROFILE>
- 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.