Re: Does anyboyd know how many bytes are in the ROWID ??

For simple tables, and locally partitioned indexes the actual stored size of the rowid in the index is 6 bytes. For globally partitioned indexes the actual stored size is 10 bytes.

If the index is a non-unique index then the rowid is appended as an extra column to the index definition and needs a further one byte as the 'length byte'. This is not needed for a unique index.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Maggie Evans wrote in message ...


>How many bytes make up the rowid?

>I need to know the row id to estimate the size of the index.

>It has changed since 8.0.  Does anybody know what it is?

>Thanks for any help.

>

>cheers;

>Owen Brandon

>

>