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

Thread: nosort in index creation

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    are there any disadvantages using nosort in creating an index

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    The only disadvantage I can think of is the following:

    You use NOSORTwith index creation on realy huge table. You are certain that rows are placed in database blocks in a sorted order, however there is a row back there at the end of the table that realy is not in the right place, it should be somewhere else for the whole table to be realy sorted. So your index creation runs runs for two hours when Oracle finds the offending row and abort the index creation. So you have just lost two hours of your's and computer's time, that's the disadvantage.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    wow that sucks. real time wasted. Is there any way to find out if the rows are in sorted order before doing this?

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Not that I'm aware of.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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