Re: Is there such thing as row migration for indexes?

jeffyee_at_hotmail.com (Jeffrey Yee) wrote:
> Hi,
>
> I'm wondering if row migration can exist for indexes.

Yes and no. In a sense, a block split is row migration en mass. But that's probably not the sense you are refering to. If indices had row migration in the way that heaps do, with head pieces left behind, it would bugger the purpose of the index.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB