If no statistics are available for a column, a message indicates the default selectivity that will be used. This message is printed for an open-ended range query on the total_sales table:
No statistics available for total_sales, using the default range selectivity to estimate selectivity.
Estimated selectivity for total_sales,
selectivity = 0.330000.
See “Default values for search arguments” on page 20 for the default values used for search arguments and “When statistics are not available for joins” on page 22 in Performance and Tuning: Optimizer for the default values used for joins.
You may be able to improve optimization for queries where default values are used frequently, by creating statistics on the columns.
