 |
|
|
A very strong impact on the performance has the database statistics, which
provides information for the Informix optimizer.
The following steps resulted in the best performance. (But for a database with
220GB disk usage, the whole procedure needs about 2:30 hours.)
-
Update the statistics data for the whole database with keyword medium
e.g: update statistics medium;
-
Update the statistics data with keyword high for all columns which are
the first column for an index
e.g.: update statistics high
for table product_item (p_id);
|
|
|
|
|
