So if You have data that is linked in any way, maybe some kind of parent and child records, You'll be able to list the whole relationship in one query. Important with recursion will be an exit strategy, in case Your data is deeply related. Queries could, under certain conditions, never return
You benefit from high performance - the query will execute as fast as possible.
Writing recursive queries is a challenging task, but the result is always worth doing it.
I agree I disagree Our site saves small pieces of text information (cookies) on your device in order to deliver better content and for statistical purposes. You can disable the usage of cookies by changing the settings of your browser. By browsing our website without changing the browser settings you grant us permission to store that information on your device.