SQL Query Taking Too long !!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SQL Query Taking Too long !!

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    SQL Query Taking Too long !!

    Hello all..

    Oracle 92/Sun 5.8

    I have 2 queries, that retreive data from the same table.

    1) Query1 : It retreives about 100kb of data.
    2) Query2: It retreives about 1MB of data.

    Query 2 is taing ages to get the data. Its taking almost 10 minutes while query 1 takes about 2 sec.

    any suggestions on what i need to look into ?...

    Thanks
    Ron

  2. #2
    Join Date
    Oct 2002
    Posts
    182
    Ron,

    In order to aid you we need you to post your query you want to tune.
    It would also help to state what columns are already indexed, etc.

    Once you post that I think we can help you a bit.
    - Cookies

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    Another developer in need of a shooting!

    Lead is gud

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Post the execution plan also.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by slimdave
    Post the execution plan also.
    MH has already done that, it's "Shoot all developers".

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