Oracle层次查询一般的资源消耗都来自于层次查询部分。 假设有以下层次查询SQL，问该如何建立索引能尽可能降低层次查询的资源消耗？ select team_id,team_id_parent,channel_id from a6 where team_id = :1 and channel_id = :2 start with team_id = :4 connect by nocycle team_id_parent = prior team_id TEAM_ID_PARENT,TEAM_ID,CHANNEL_ID