I have a view V1 created on a table T1 to show me hierarchy details using level column. Have another view V2 created with some other tables and above view V1 which uses level column from V1.
As its taking too long to query data from V2 , i want to change V2 to directly create level column in V2 itself by changing the view to query all the tables related instead of involving V1. But now when iam querying V1 after changes ....queried rows are differing as i have the connect column as one of V2 s columns.
Finally the level ..sorting is happening on the data queried in the view and not on the table T1.
Can anyone suggest me a solution how i can extract all the data which it used to query when V1 was involved in V2 query conditions.