Re: locally managed tablespace & dictionary managed tablespace

I agree, especially if you consider the option for turning the reference tables into single table hash clusters.

But I wouldn't hold it up as a general suggestion as it's too easy to set it up badly.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______January 21/23


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Richard Foote wrote in message ...



>Just to follow on from the above, if you have a whole stack of very

small


>lookup tables, this could be a good reason for using a small block

sized


>tablespace (9i of course).

>

>By having a 2K block size, you then can have a LMT with a uniform

size of


>4K. If you have many tables in this category, you can potentially

reduce


>space consumption by an amount.

>