Help on Tuning the sort
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Help on Tuning the sort

  1. #1
    Join Date
    Apr 2001
    Posts
    8
    Hi ,

    Could any one help me out on the following?

    I have a query which returns about some 500K records and it is very slow if I put the 'ORDER BY' clause. It takes about 10 mins with sorting and only 9 seconds without the 'ORDER BY'. I have increased 'SORT_AREA_SIZE' but that didn't help me. Also I don't see much disk sorting. Disk sorting is less than 1%. I am on 8.1.7. What else I can do to take the query down to say less than minute? Thanks a lot.

    Your help is greatly appreciated.

    Thanks again.

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    More info required

    Hi, 9th oct 2001 12:06 hrs Mumbai

    I would like to know whether in your Query you have join Condition if so are the joined column indexed please post me with details of the Query and details i have requested .

    cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Kannan,

    First thing that you can do is to make sure
    there is an index of the field you use in your ORDER BY statement.

    If no improvement then post your query here as what padman asked.


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