Re: Optimizer showing wrong rows in plan

On Mon, 29 Mar 2010, Tadipathri Raghu wrote:
> As per the documentation, one page is 8kb, when i create a table with int as
> one column its 4 bytes. If i insert 2000 rows, it should be in one page only
> as its 8kb, but its extending vastly as expected. Example shown below,
> taking the previous example table test with one column.

There is more to a row than just the single int column. The space used by
a column will include a column start marker (data length), transaction
ids, hint bits, an oid, a description of the types of the columns, and
finally your data columns. That takes a bit more space.

Matthew

--
If you let your happiness depend upon how somebody else feels about you,
now you have to control how somebody else feels about you. -- Abraham Hicks