alter index rebuild - where sorted ? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: alter index rebuild - where sorted ?

  1. #11
    Join Date
    Jan 2004
    Posts
    11

    to sort or not to sort...

    hi slimdave,

    Originally posted by slimdave
    Are there inserts/updates/deletes going on
    against the bitmap indexed tables?
    ...guess so, because index and table seem to
    increase or decrease quite similar

    next friday i'll try to increase the
    sort_area_size parameter dynamically to check it's
    impact to my sorting operations

    thanks

  2. #12
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by abhaysk
    It do require quite a significant amount of sorting, as the data is read from TABLE for online...
    Right, my bad.
    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