Improving Hierarchy LEVEL Access Performance Using Recursion Function

Abstract

In the Current Data base sql query for fetching Hierarchical data like supervisor hierarchy or organization hierarchy etc standard connect by prior command used for fetching data so connect by prior command take longer time for fetching the hierarchical data level for supervisor hierarchy or organization hierarchy etc. As a workaround, we will provide solutions for fast access for hierarchical data level for supervisor hierarchy or organization hierarchy etc by using recursive function in sql statement
DOI: 10.17762/ijritcc2321-8169.150630