Hi Rimao:

It is getting somewhat clear now.

A. thus, for existing ones, after partition, only need to recreate clustered index. No down-time for clients at all?

B. Does it mean to drop all partition related func/schem binding..., will put back to un-partition mode?

C. the range value should be focused on linking field, the most frequently to be used?

Thanks for your help.
-D