EXPLAIN EXTENDED

How to create fast database queries

Archive for May 25th, 2009

Genealogy: finding a descendant

Comments enabled. I *really* need your comment

In the previous article I described an efficient way to build a genealogy with a hierarchical query in Oracle:

Now, I'd like to describe a query to check if one entity in the table is a descendant on another one.

Let's create a sample table:
Read the rest of this entry »

Written by Quassnoi

May 25th, 2009 at 11:00 pm

Posted in Oracle