Esteemed Wizards,
I have a theoretical question. If I have a lookup table, very static,
and very small, does it make sense to put an index on the table or
would creating a hash cluster be better.
For example:
create table state (
abbrev varchar2(2) not null,
country varchar2(8) not null,
name varchar2(30) not null);
Other than in eastern europe, the values in this table do not change
often.
I put an index on abbrev and country so that the table does not
have a full table scan, and throw off the rule based optimizer. This
makes two I/Os to read the index and the table.
According to Oracle, turning this into a hash cluster would reduce it
to one I/O.
From a theoretical standpoint, would it be more efficient to create a
hash cluster? How about the practical aspect?
Any replies are appreciated.
Bob Walters bobwal_at_infocom.com
Florists' Mutual Insurance Co.