|  | Posted by eavery on 03/14/07 19:13 
I'm assuming that
 "However, this operation occurs
 offline, and depending on the extent of repartitioning, may be
 resource-intensive. "
 
 means that effected indexes/tables etc are locked until the
 repartitioning is finished.
 (Versus on-line which would allow users to proceed).
 
 As far as the indexes go, it maybe cheaper to drop the index, change
 the function, then re-create the index.
  Navigation: [Reply to this message] |