Is the default freespace of 200 bytes also applied to extended pages?

are extended table pages also reserving 200 bytes which will be unused if data is stored into this page?

page-size pages

asked 17 Jul '23, 10:24

Martin
9.1k●130●170●257
accept rate: 14%

Just to clarify: Are you relating to "extension pages" (see here) and the PCTFREE default?

(Note: I don't know the answer, but assume "yes", as the PCTFREE value seems to apply to the whole table...)

(18 Jul '23, 06:06) Volker Barth

Replies hidden

yes correct

(18 Jul '23, 09:40) Martin

flat view

Be the first one to answer this question!

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

question asked: 17 Jul '23, 10:24

question was seen: 226 times

last updated: 18 Jul '23, 09:40

SAP SQL Anywhere