hi,
I got rather big schema where user objects are around 80000.
I often want to find a specific package (navigating the tree when I got 20000+ packages takes to long), but the find dialog is to slow.
Maybe there needs to be another search dialog that only searches in object names.
When I go to the "Find Database Objects" window, and click only in "Package Specifications", type in the "Text to find" box the text "ABCD" and press search, the search takes more than 20 minutes.
executing the following two statements both takes only matter of milliseconds:
select * from user_objects where object_name like 'ABCD%'
select * from all_objects where object_name like 'ABCD%'
I'm trying to get more people in my company to switch from sql navigator to pl/sql developer, but this slow feature makes them not want to switch since they use this feature a lot in sql navigator and it takes very short time there.
Is there another way to find objects quickly in pl/sql developer or is it on the plan in future releases?
I got rather big schema where user objects are around 80000.
I often want to find a specific package (navigating the tree when I got 20000+ packages takes to long), but the find dialog is to slow.
Maybe there needs to be another search dialog that only searches in object names.
When I go to the "Find Database Objects" window, and click only in "Package Specifications", type in the "Text to find" box the text "ABCD" and press search, the search takes more than 20 minutes.
executing the following two statements both takes only matter of milliseconds:
select * from user_objects where object_name like 'ABCD%'
select * from all_objects where object_name like 'ABCD%'
I'm trying to get more people in my company to switch from sql navigator to pl/sql developer, but this slow feature makes them not want to switch since they use this feature a lot in sql navigator and it takes very short time there.
Is there another way to find objects quickly in pl/sql developer or is it on the plan in future releases?
