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,
Printable View
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,
Are we talking about plain views here? Do you realize a view is nothing but a stored query?Quote:
Originally Posted by iris
Oracle optimizer will use base table's statistics and indexes.
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.Quote:
Originally Posted by iris
;)
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.Quote:
Originally Posted by iris
Developers should develop the application on top of the database infrastructure - not the other way around.