ixutil -crejidx <dataset,column> <dataset,column> -libpath <physical-path> -joinparts <number>
ixutil -deljidx <dataset,column> <dataset,column> -libpath <physical-path>
ixutil -lstjidx -libpath <physical-path> [-verbose]
ixutil -reorg <index1,index2,... | _all_> -dsn <dataset> -libpath <physical-path>
ixutil -runstats <index1,index2,... | _all_> -dsn <dataset> -libpath <physical-path> [-maxruns <number>]
ixutil -statjidx <dataset,column> <dataset,column> -libpath <physical-path>
ixutil -stats <index1,index2,... | _all_> -dsn <dataset> -libpath <physical-path> [-dist]
ixutil -help
creates a join index for a pair of tables that are in the same domain. The join index can be used to optimize parallel range joins. The columns must already be indexed. The -libpath argument specifies the physical path of the domain that contains the table. The -joinparts argument specifies the number of parallel join work units. Parallel join threads join the work units concurrently and then merge their partial results into the final result. The recommended number of parallel join work units is two times the number of processors.
deletes a join index. The -libpath argument specifies the physical path of the domain that contains the table.
lists the join indexes that are in a domain. The -libpath argument specifies the physical path of the domain that contains the table.
reorganizes the specified set of indexes in a table to reclaim wasted disk space and to aggregate the per-value segment lists. Reorganizing an index results in optimal disk usage and query performance. The -dsn argument specifies the table that contains the index. The -libpath argument specifies the physical path of the domain that contains the table.
prints the run statistics for each index for the specified set of indexes that belong to a given table. Run statistics provide an indication of how the values of a particular index are sorted in relation to their observation numbers. By default, the ixutil utility run statistics display the ten longest runs in the table. A run is defined as the number of successive rows that contain the same index value. The -dsn argument specifies the table that contains the index. The -libpath argument specifies the physical path of the domain that contains the table. In addition, you can use the -maxruns argument to change the default setting of 10 runs to any integer in the range 1–100. You can use run statistics to construct more efficient BY and WHERE clause constructs for the table.
gathers statistics about the join index parts. The average join row percentage indicates the average number of rows that a parallel join work unit reads. For example, a row percentage of 75 indicates that the parallel join work unit uses 75% of the rows that it must read. The closer the percentage is to 100, the better the performance. The percentage increases as the distribution of the data for the join column becomes more sorted. The -libpath argument specifies the physical path of the domain that contains the table.
prints the disk usage statistics and segment list fragmentation statistics for the specified set of indexes that belong to a given table. Each value in the index has a segment list. A value's segment list can become fragmented when the index is updated. An index that is highly fragmented can degrade query performance and waste disk space. The -dsn argument specifies the table that contains the index. The -libpath argument specifies the physical path of the domain that contains the table. Use the -dist option to include the distribution statistics with the index statistics.
prints a list containing the command-line usage and option switches for the ixutil utility.