![]() Here, you may see gaps when looking at the final result set. ![]() But, other sequence values might survive through predicate evaluation and filtering. For example, in an access plan, a sequence value may be generated towards the bottom of the access plan, but then the particular row that generated that value might not qualify some predicates higher up in the access plan such that the particular sequence value did not result in any output. ![]() However, it entirely depends on the access plan. In case of single node system, you will see the unique values in proper order in most simple cases. Please refer to the DB2 Infocenter for more details. When CYCLE is in effect, then duplicate values can be generated for the sequence by specifying MIN and MAX limit while creation. It is ideally used for generating unique values to satisfy different business needs, provided, you have not specified the 'CYCLE' clause with CREATE SEQUENCE command. How does DB2 Sequence behave in Single and Multi Node System? Why do you see gaps in Sequence generated values ?Ī DB2 Sequence is a database object that allows you to generate the automatic values.
0 Comments
Leave a Reply. |