Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Pakistan
    Posts
    17

    Red face Unanswered: SQL quiries are too slow

    Hello all,

    I have some quiries with joins of different tables and at the end order by statement. These quiries take very longer time from 7 Min to more.
    The Records in the datatbase are more than half million
    When ever I remove the order by clause the the quiries pull out with in seconds.

    Please help me out of this problem.
    Thanks in advance
    Istikhar Ahmad
    ------------------
    Tel: (92-42) 111000911
    iahmad@i2cinc.com
    http://www.i2cinc.com

  2. #2
    Join Date
    Sep 2002
    Posts
    2

    Re: SQL quiries are too slow

    Run with set explain on and see what goes there !

    For optimize if the query return many records try to to

    select ... into temp temptable
    create index on temptable
    select * from tenptable

    Hope that help you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •