Oracle中start with…connect by prior怎么优化？
一个地址表一共有8级地址，传入地址id，查询所有上级地址，代码为：

select address_id    addressId,
           address_name  addressName,
           address_level addressLevel
          from rm_address t
             start with t.address_id = #villageId#
            connect by t.address_id = PRIOR t.PARENT_ADDRESS_ID
             order by address_level
             
             

现在查询很慢，求问怎么优化？## 标题文字 ##