D
Dmitri Levin
Guest
I would make a single extent for each area. For performance -- there is no difference. For maintenance one extent is easier too. In a very rare, exotic scenario when the database crashed, and you know which extent is at fault, it is obviously more easier to dig data from a 256MB extent than from 1.5GB extent. Those are the cases I would not consider for making a decision. So I would go with 1 extent. YMMV.
Continue reading...
Continue reading...