Hi,

Thanx for your reply.

But I would like to know in what way it helps.
It is going to occupy more no. of extents and if a full table scan is going to be done then it has to go through all the extents(extents need not be contiguous). So the amount of time it takes to read the data increases and hence some performance degradation will be there.

Please clarify.

Thanks.
Vijay.