Results 1 to 4 of 4

Thread: Performance Query

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    75

    Performance Query

    Will commit inside a loop reduce the performance of query? Also I have a doubt about using PL/SQL. Will using PL/SQL has any effect on performance?


  2. #2
    Expert Member
    Join Date
    May 2006
    Answers
    114

    Re: Performance Query

    Generally to say I would suggest not to use commit inside loop and also I would suggest using SQL wherever possible by reducing PL/SQL. But when needed it is used as per the requirements.


  3. #3
    Contributing Member
    Join Date
    May 2006
    Answers
    72

    Re: Performance Query

    When I was going through this discussion I happened to come across some concept or term called Parallel Query. But I could not get any information or description about this. Somebody highlight whether it is related to this discussion. In other words can this Parallel query can be used to improve performance. If so what does the concept actually mean?


  4. #4
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: Performance Query

    Quote Originally Posted by joel View Post
    When I was going through this discussion I happened to come across some concept or term called Parallel Query. But I could not get any information or description about this. Somebody highlight whether it is related to this discussion. In other words can this Parallel query can be used to improve performance. If so what does the concept actually mean?
    Definitely Parallel Query will improve Performance but the commit statement problem is nothing to do with Parallel Query.

    Oracle implemented the concept of Parallelism using Oracle Parallel Query(OPQ) or Parellel Execution.
    When Oracle has to perform a large, full-table scan, OPQ can make a dramatic difference in the response time
    Parallelism is the idea of breaking down a task so that, instead of one process doing all of the work in a query, many processes do part of the work at the same time.
    The performance will improve drastically by this method.

    When SQL statement is executed in Oracle, multiple processes work together simultaneously to run a single SQL statement.
    By dividing the job necessary to run a statement among multiple processes, Oracle can run the statement more quickly than a single process.
    This is called Parallel Execution or Parallel Processing.

    *** Innila ***

    Last edited by Innila; 02-20-2007 at 08:16 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact