Re: Separating Tables and Indexes

fitzjarrell_at_cox.net wrote:
> I separate them for management reasons; I can create tablespaces with a
> smaller extent size for the index objects than I would need for the
> table objects (as usually indexes require less space than tables).
> Again, this is more a personal preference than a hard-and-fast rule.

I understand, and agree with, the idea that you might separate objects by appropriate extent size (though my criteria would be growth patterns and not space usage). I don't see how that translates into a recommendation to separate indexes from tables because indexes take less space than tables. They will take less space than the table with which they are associated (nearly always and ignoring lobs), but I'm willing to bet that an index on orderid for amazon.com takes more space than an index on the ship_country lookup table in the same database :)

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/ Received on Tue Aug 01 2006 - 09:26:24 CDT