are extended table pages also reserving 200 bytes which will be unused if data is stored into this page?
asked 17 Jul, 10:24
Martin 9.0k●127●166●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...)
yes correct
Once you sign in you will be able to subscribe for any updates here
Answers
Answers and Comments
Markdown Basics
learn more about Markdown
Question tags:
page-size ×12 pages ×5
question asked: 17 Jul, 10:24
question was seen: 107 times
last updated: 18 Jul, 09:40
What particular statistics should one look at to help decide the best database page size to use?
SA 17.0.10: Is it possible to use databases with different page sizes under one server ?
How do you change the page size of a database?
When is the information returned by sa_table_page_usage() updated?
Legacy collation matching
32K Page size
Page Sizes in 2023
Page Size for SAN Performance
pool(size) prepared statements adjustable?
Assertion failed: 200166
First time here? Check out the FAQ!
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...)
yes correct