need more understanding
daniesh shaikh, February 18, 2008 - 9:43 am UTC
Hi Tom,
could you please explain me the more specificially.
you mean to say if we have lots of extents then reorganization problem will be more
Thanks,
Danish
February 18, 2008 - 10:01 am UTC
you missed the point entirely.
the question was nonsensical, meaningless...
Suffice to say - the number of extents will not readily affect the runtime performance of
a) an index access (cannot, we read a rowid and go to that row - we do not care if there is 1 or 1,000,000,000 extents - the results would be the same)
b) a full scan - since the vast preponderance of the time is spent actually doing physical IO - the amount of time we'd spend managing our way through 1 or thousands/millions of extents would be meaningless.
So, I think the person asking the question was trying to see if you would do something about a segment in 30 extents.
I would do nothing, other than say "job well done, lets get on with it now"
daniesh shaikh, February 18, 2008 - 10:18 am UTC
ok Tom
you mean he was trying to check me. i will keep in next time when i will go for interviews.anyways thanks for clearing my doubts.