Hi.
Assume I have dbspace myspace created from two chunks:
size (p) used (p) free(p)
chunk1 100 95 5
chunk2 100 50 50
Now.
In myspace I have table mytable among other tables.
Lets say that:
I put some initial data to mytable (of some size) and other tables are static and don't grow.
Now.
If on mytable (that now has some size) there are constantly deletes and inserts does it mean table will not need extention until there
is more data than current size?
What I mean here is if there is free size on chunks like above they will be used by mytable when needed or size of mytable stay fixed?
Now. If I delete all data completely from mytable it doesnt mean free space in chunk will be automatically changed to higher.
But if I truncate the table it will return free space in chunks?
If I drop the tableit will return free space in chunks?
Assume I have dbspace myspace created from two chunks:
size (p) used (p) free(p)
chunk1 100 95 5
chunk2 100 50 50
Now.
In myspace I have table mytable among other tables.
Lets say that:
I put some initial data to mytable (of some size) and other tables are static and don't grow.
Now.
If on mytable (that now has some size) there are constantly deletes and inserts does it mean table will not need extention until there
is more data than current size?
What I mean here is if there is free size on chunks like above they will be used by mytable when needed or size of mytable stay fixed?
Now. If I delete all data completely from mytable it doesnt mean free space in chunk will be automatically changed to higher.
But if I truncate the table it will return free space in chunks?
If I drop the tableit will return free space in chunks?