Changing fragment size



In the documentation for the create table with clause, it mentions:

fragment_size | Number of rows per fragment that is a unit of the table for query processing. Default = 32 million rows, which is not expected to be changed.

It says it is not expected to be changed…
does that mean changes will cause it to fail?
it won’t let you change it?

Just looking for some clarification,


The default isn’t going to change, but you can change it.
I change to improve the performance while using the cpu if the number of fragments is lower than number of cores



@tflinz here is some additional information about when you might want to change fragment size.

The wording in the docs needs a little more color