-
Analyzing Views
How to analyze the Views, in terms of performance?
I was asked, whether the application team are creating Views keeping in mind the performance of Database.
How can we check this from Oracle apart from third party tools.
thanks,
Last edited by iris; 12-11-2010 at 03:55 PM.
-
Originally Posted by iris
How to analyze the Views, in terms of performance?
Are we talking about plain views here? Do you realize a view is nothing but a stored query?
Oracle optimizer will use base table's statistics and indexes.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
See the application is under development stage, as a DBA how to check or analyze the tables and views are designed considering Database performance.
Like for example, Are developers are creating proper indexes method? etc
thanks,
-
It'a a mistery...
Originally Posted by iris
See the application is under development stage, as a DBA how to check or analyze the tables and views are designed considering Database performance.
Like for example, Are developers are creating proper indexes method? etc
thanks,
Some things will be obvious in development (like missing indexes), but other wise you may need to execute the query in production and examine the execution plan.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by iris
See the application is under development stage, as a DBA how to check or analyze the tables and views are designed considering Database performance.
Like for example, Are developers are creating proper indexes method? etc
Developers shouldn't be creating indexes (or tables or views or etc etc) those are the roles of the Database Architect and the Data Modeler.
Developers should develop the application on top of the database infrastructure - not the other way around.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|