Quote:
Originally posted by efrijters
I think the answer is YES.
But extents of 40KB are good, because there are also a lot of tables that only have 1 or 2 rows. So, rebuilding those tables to extent size 256KB would only waste hard disk space.
Now I understand the TS_SMALL, TS_MEDIUM, TS_LARGE story better.
Thanks everybody!
Yes, this seems fair, but i should add that this only affects large i/o requests, like full table or fast full index scans. Accessing tables by rowid through the index, or index operations other than FF scan, get no benefit from this extent sizing issue.