Re: Cached tables

From: Simon Griffiths <s.griffiths_at_virgin.net>
Date: Thu, 25 Jun 1998 22:42:23 +0100
Message-ID: <3592C43F.9A71B552@virgin.net>

Ian Jennings wrote:

> I have several small tables (between 10 and 15 rows) that are lookup
> tables and that are created as cached and for which the values never
> change.

If you switch on hash joins - (I think it's HASH_JOINS_ENABLED ininit.ora ) and run with cost-based optimiser then you may well get some performance gains. You'll probably not need the indexes for performance, but they'll do no harm !

Simon. Received on Thu Jun 25 1998 - 16:42:23 CDT