Re: Will ROWID change during DB Runing??

Grant Zhou wrote:

> BTW,
> The table have about 80K records and have index on it.
> When will the data partition move? frequent insert or delete?
> As I know, we have no such operation.
> Will very frequent update can cause partition move?
>
> Thanks very much!
> Best Regards,
> Grant

They will change whenever the update causes the record to be properly placed into a different partition. If the update doesn't affect the partition key ... it won't change partitions.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---