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

Thread: query tuning

  1. #1
    Join Date
    Jan 2005
    Posts
    221

    query tuning

    tbd
    Last edited by hannah00; 03-16-2005 at 11:11 AM.

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    DB version?
    Assistance is Futile...

  3. #3
    Join Date
    Jan 2005
    Posts
    221
    9I

    THANKS

  4. #4
    Join Date
    Jan 2005
    Posts
    221
    any imput would be greatly appreciated

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Merge join may slow down execution. Try HASH join.

    Also you have to treat date datatype as date.
    See below:
    '01-NOV-2004' BETWEEN AGH.EFF_DT_FROM AND AGH.EFF_DT_TO

    Tamil

  6. #6
    Join Date
    Jan 2005
    Posts
    221
    thanks Tamil,

    the problem is sorting, it kept ran out the temp tablespace even it already had 6G.

  7. #7
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    A merge join will probably use more memory\temp tablespace for sorting than a hash join. Try Tamil's suggestion. Assuming you are using CBO (rahter than RBO) it should be the most efficient approach.
    Assistance is Futile...

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