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

Jeffrey Yee wrote:
> Hi,
>
> I'm wondering if row migration can exist for indexes. Since we can
> specify pctfree, I would assume this is possible. If so, I wonder how
> I can check for row migration in indexes, since the dba_indexes does
> not have the row_chain column, which is populated when analyze.
>
> Please advice. Thank you.
>
>
> Best Regards,
> Jeffrey Yee

Go to http://tahiti.oracle.com and look up PCTFREE and INDEX.

Also spend a bit of time with a book explaining what a B*Tree index is, its structure, and how it works.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)