oracle8.1.6 select /*+INDEX(child categories_left_ix)*/ child.category_id from categories parent, categories child where parent.category_id = :category_id and child.left_ind >= parent.left_ind and child.left_ind <= parent.right_ind and child.tree_id = parent.tree_id order by child.left_ind