Re: Need index on 2 column table?

search for "oracle index organized table organization"

and you might find this:
http://www.oracle.com/technology/products/oracle9i/pdf/iot_twp.pdf

and lots of other articles.
(wow - 2001. I didn't realize 9i had been out that long)

This sounds like an excellent candidate for an IOT. Index clusters are another possibility.
single table hash clusters are another possibility. It depends upon if you know how many values and keys will be needed. The safest call is to just go with the IOT.

test them all and see which works best.

-bdbafh Received on Thu Aug 04 2005 - 17:58:05 CDT