I have a usecase wherein I need to use External Tables.Which is better with respect to performance and code-readibility?
1)Creating an External table → Creating a view based on external table → Creating a local table based on this view → creating a view based on local table.
2)Creating an External Table → Creating a local table based on External Table →Creating view based on local table.
Local table creation is needed here for performance optimisation in case of complex queries.Can someone suggest out of 1) and 2) which is better approach?