Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Query Optimisation

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?

Comments
Post Details
Added on Jun 20 2023
1 comment
194 views