DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Analyzing Applications Tables

  1. 04-02-2003, 05:53 PM #1
    pcotten
    pcotten is offline Member
    Join Date
    Jan 2001
    Posts
    138

    Analyzing Applications Tables

    Is there a need to or danger because of, analyzing Apps tables, for example, AP_INVOICES_ALL owned by AP user. I thought analyzing creates statistics which in turn degrades performance. Thanks.
    Reply With Quote Reply With Quote
  2. 04-14-2003, 05:40 AM #2
    rohitsn
    rohitsn is offline Advisor
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Re: Analyzing Applications Tables

    Hi,
    Analyzing the APPS tables,doesnot degrade the performance but improves the performance as the latest statistics is available to the Oracle optimiser for creating better and efficent execution plans.

    Regards,
    Rohit Nirkhe,Oracle/Apps DBA,OCP 8i,OCA 9i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com
    Reply With Quote Reply With Quote
  3. 04-18-2003, 05:13 AM #3
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Not Always it improves.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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