set option min_table_size_for_histogram

[former_SQLA_member1694872]

I want to change the option MIN_TABLE_SIZE_FOR_HISTOGRAM . But how do I check its value before changing?

select * from sysoption -- this option will not appear.

I'm using Adaptive Server Anywhere Database Engine Version 9.0.2.3951

[MarkCulp · Accepted solution]

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.