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

Thread: Sql Tuning

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    Sql Tuning

    could someone please help me tune this sql, it kept running out of space on TEMP

    SELECT ME.STREET, MO.STREET

    FROM MAP ME, COUNTY LCM, MAP MO

    WHERE ME.FEATURE = LCM.id AND LCM.CITY = MO.FEATURE

    AND ME.num = '1' AND MO.num = '1'

    MINUS

    SELECT active_STREET, related_STREET FROM FEATURE_DATA;


    thanks

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    Add more TEMP space.
    Pipe it through Lecco for a re-write.
    Buy Lecco.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Oct 2003
    Posts
    312
    lecco?????


    what's that????

    Any advises???

  4. #4
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Start on Autotrace and send us the execution plan of your query.
    In addition,check out if your columns in the "where" close are indexed.

    Regards,
    Nir

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