Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

mardi 26 mars 2013

Oracle White Paper :SQL Profiles: Technical Overview



What is a SQL profile? 
            A SQL profile is a set of auxiliary information specific to a SQL statement. Conceptually, a SQL
profile is to a SQL statement what statistics are to a table or index. The database can use the
auxiliary information to improve execution plans.
A SQL profile contains corrections for poor optimizer estimates discovered by the SQL Tuning
advisor. This information can improve optimizer cardinality and selectivity estimates, which in
turn leads the optimizer to select better plans.
The SQL profile does not contain information about individual execution plans. Rather, the
optimizer has the following sources of information when choosing plans:
• The environment, which contains the database configuration, bind variable values, optimizer
statistics, data set, etc.
• The supplemental statistics in the SQL profile
 Therefore, SQL profiles just guide the optimizer to a better plan.
Sql-profiles-technical-overview-128535

28 commentaires:

  1. Nice news and thanks for sharing this here to let me know this updates,please know the recent updates by visiting this link also…because I had gain some info from here also: SQL Server Jobs

    RépondreSupprimer
  2. Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/blog/2016/11/12/dataguard-implementation-steps/

    RépondreSupprimer
  3. Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/blog/2016/11/07/stp-loop-guard/

    RépondreSupprimer
  4. Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/vmware-training-pune-online/


    RépondreSupprimer
  5. You should also check out Jobs Micro. This is a leading job search website in India which has hardware engineering job vacancies in pure job listing. This website benefits both the employees and the employers. Hope it helps you.

    RépondreSupprimer
  6. Thanks for your informative article, Your post helped me to understand the future and career prospects & Keep on updating your blog with such awesome article.
    python training in tambaram
    python training in annanagar
    python training in jayanagar

    RépondreSupprimer
  7. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!

    Simple Linear Regression

    Correlation vs Covariance

    RépondreSupprimer
  8. The post is written in very a good manner and it entails many useful information for me. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept.keep it up!!

    android training in chennai

    android online training in chennai

    android training in bangalore

    android training in hyderabad

    android Training in coimbatore

    android training

    android online training

    RépondreSupprimer
  9. Ce commentaire a été supprimé par un administrateur du blog.

    RépondreSupprimer
  10. Need help to make the major shift to a new ERP?, Nevas Technologies can help support your current Dynamics NAV Environment irrespective of the version that you are on.We Provide Functional, Technical, Production support and infrastructure (Server Maintenance, Finetuning, and so on…) services for your current Navision application. We also provide upgrade services of your old MS Navision version to the latest Dynamics Navision 2016/2017/2018 versions if you are not ready to upgrade to Dynamics 365 Business Central or Unified Operations.

    Upgrading to Microsoft Dynamics NAV is one of the best possible investments you can make in your business. In addition to the advantages provided by new features, platform, and fixes to previous versions, an upgrade allows you to take full advantage of breakthrough new innovations in technical and functional aspects of the software, including:

    However, while we support customers with older Dynamics NAV systems, we love to talk about bringing our customers into the new world of Dynamics 365 Business Central (and you can check out this blog to find out more about upgrading).

    With our experience, we’re confident that we have the expertise and experience to solve any and every Dynamics NAV issue under the sun

    That said, we also recognize the financial and time pressures may mean people want to stay on their old version for now.
    Migrate Dynamics NAV4.0/2009 R2/2013 R2 customers
    Upgrade Dynamics NAV 2015/16 to 2018 or MS Dynamics 365 BC or F&O
    NAV 2016/ Navision 2018 to MS Dynamics 365

    RépondreSupprimer
  11. I wish to show thanks to you just for bailing me out of this particular
    trouble.As a result of checking through the net and meeting
    techniques that were not productive, I thought my life was done.
    dot net classes in Chennai
    core java training institutes in Chennai
    Best Manual Testing Training in Chennai

    RépondreSupprimer
  12. I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts.
    data analytics training in hyderabad

    RépondreSupprimer