Analyzing Views

[iris]

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,

[PAVB]

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.

[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,

[LKBrwn_DBA]

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.

[PAVB]

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.