I want to change the option select * from sysoption -- this option will not appear. I'm using Adaptive Server Anywhere Database Engine Version 9.0.2.3951 |
The MIN_TABLE_SIZE_FOR_HISTOGRAM option was removed in 9.0.2 - see the notice in the documentation. Since 9.0.2 SQL Anywhere (aka Adaptive Server Anywhere) will create histograms for any table with five or more rows. |