[PHOENIX-2050] Avoid checking for child views unless operating on table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.3.1
• Fix Version/s: 4.5.0
• Labels: drop patch view
• Flags: Patch
• Assignee: James R. Taylor
• Reporter: Arun Kumaran Sabtharishi
• Created: 18/Jun/15 03:19
• Updated: 21/Nov/15 02:18
• Resolved: 01/Jul/15 01:27

Description

Whenever a view is dropped, MetaDataEndPointImpl.findChildViews() checks whether it has child views or not. This is doing a full scan in all the rows in SYSTEM.CATALOG which reduces performance. When the number of rows is very high, it causes timeout. The check has to be done only for the tables.