Spring 2015, Franck Pachot. You must have system statistics if you want the optimizer to evaluate correctly the cost of full table scans vs. index access. But you have two options to gather them: NOWORKLOAD and WORKLOAD. The latter seems to be the more accurate one because it fits your workload. But do you really know how they are calculated?