Analyzing Views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Analyzing Views

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    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 02:55 PM.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by iris View Post
    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.

  3. #3
    Join Date
    Mar 2008
    Posts
    140
    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,

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Talking It'a a mistery...

    Quote Originally Posted by iris View Post
    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

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by iris View Post
    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
  •  



Click Here to Expand Forum to Full Width