Re: Cached tables - Thanks

> Ian Jennings wrote:
>
> > I wonder if someone could advise me please. I am trying to figure out
> > the best way of tuning an Oracle 7.3 database running on an NT4 machine.
> >
> > 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. It seemed to make sense to keep them cached but what are the
> > implications of having indexes on them? They are used in a *lot* of
> > joins. Would not indexes slow down any access to them if they are
> > already available? Each table has a row size of about 60.

If you are using cost based optimizer - it is very likely that it will realize that it can retrieve the entire table info with one or two I/O's and then intentionally ignore the indexes. If you are not utilizing the CBO then I would decide if the indexes are required(constraints - primary key) or add hints to your joins in order to perform your own optimization.

Joe Lieto
Redwood Solutions

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jun 29 1998 - 11:22:17 CDT