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

Thread: Minimize sorts ?

  1. 05-29-2002, 03:14 AM #1
    mattias
    mattias is offline Junior Member
    Join Date
    Jan 2002
    Posts
    48

    Question

    Im running a batch-job that rebuilds indexes. This requires a lot of temporary sort area. Is there any way that I can rebuild an index without sorting/minimize sorting ? Any way to speed this process up ? Oracle version 8. I increased sort_area_size which made the process faster and the usage of temp tablespace a bit less.
    Reply With Quote Reply With Quote
  2. 05-29-2002, 05:03 AM #2
    anandkl
    anandkl is offline Senior Advisor
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Also use the clause 'UNRECOVERABLE' in the INDEX REBUILD statement this will not generate any redo while index is rebuilding and the rebuild will be faster.

    regards
    anandkl
    anandkl
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width