Q
Problem solve Get help with specific problems with your technologies, process and projects.

How many tables can you use in a single view?

Are you aware of any performance issues in creating a single view using 10 tables? Those ten tables were used for some other few views. I'd like to know max-to-max how many tables can we use in single view.
I assume that you are joining 10 tables. Such a join is likely not to perform well, but to be sure, create the view in a development database and test the performance of the queries you intend to run against it. There is no substitute for empirical evidence!

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close