Snowflake sequences do not guarantee gap-free numbers. The ORDER vs NOORDER behavior does not affect the gaps in sequence numbers. To generate a guaranteed contiguous sequence of numbers, one potential solution is to use the ROW_NUMBER() window function.
