Re: Lookup tables

Index Organized Tables would be a good way to go for your lookup tables. They are "cheaper" to access generally than heap lookup tables if you are accessing by primary key. They also use less space as you don't need to maintain a separate index, but in the case of small lookup tables, the space savings are minute. Of course, the relative costs of these things change with every release of Oracle, but generally IOTs are good for this.

Regards

Adrian

--
Posted via dBforums
http://dbforums.com