A recursive query is a named query expression that references itself in its definition. The self-referencing capability provides a simple way to search a table using iterative self-join and set operations.
The recursive query feature reduces the complexity of the queries and enables them to execute more efficiently.
Recursive queries are implemented using the WITH RECURSIVE clause in the SELECT statement and the RECURSIVE clause in the CREATE VIEW statement.