This provides a breadth-first search.
这提供了一种广度优先的搜索。
SEARCH BREADTH FIRST is the default sequence and returns all data on the same level first before returning any data on the next level.
SEARCH BREADTH FIRST 是默认顺序,在返回下一层数据前会先返回同级的所有数据。
The underlying problem is that DB2 processes recursion by essentially producing one level of recursion at a time (breadth first), while Oracle uses depth first.
在底层,DB2 处理递归时采用的方法是逐层递归(广度优先),而 Oracle 采用的是深度优先的方法。
应用推荐