1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

i want to reduce the execution time of query.

Discussion in 'SQL PL/SQL' started by jyothibasu24, Dec 6, 2013.

  1. jyothibasu24

    jyothibasu24 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    HI ALL,

    I have 3 individual query i just want to join the 3 queries and got output .
    That i did, but the problem is it will take more time . i want to reduce the execution time

    give me any idea or suggestions .

    Thanks in Advance
    Jyothibasu
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Provide queries here, then it will help others to give solution.
     
  3. jyothibasu24

    jyothibasu24 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Hi all ,
    If try to Post my query here but it shows the below msg ,what can i do now

    Oops! your Post seems to be a SPAM! If you are posting live links, you need to have made at least 5 Posts as required by the administrator. Please edit your post or contact the administrator.


    Jyothibasu
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi, put your query in .txt file then attach it here.
     
    jyothibasu24 likes this.
  5. jyothibasu24

    jyothibasu24 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Hi Sir,

    Here Attach my query please find it and give some idea.
     

    Attached Files:

  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,346
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Create table statements and sample data would help tremendously in addressing your problem.
     
  7. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    That msg is if there are links in your post. Remove the links and it should post fine.

    And as Zargon said, ideally you should provide create table statements and sample data and your queries and possibly the explain plan. Then someone can tell you exactly what is wrong or what can be improved.