Monitoring Fragment Use

Once you determine a fragmentation strategy, you can monitor fragmentation in the following ways:

• Run individual onstat utility commands to capture information about specific aspects of a running query.
• Execute a SET EXPLAIN statement before you run a query to write the query plan to an output file.