Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> index organized tables
Hello all,
I have a table containing a shippingid,eventrank,eventsuffix,placeofentry,
eventcode,timestamp,information. Now, in the OLTP system, the same event
can occur multiple number of times, but each time the information
can be different. As a result the only way to have a key is to make a
composite key of all the fields. I have a few questions.
Does this approcach make sense ?
Doesn't this result in an index organized table and is that good or
bad,performance-wise ?
I will be searching this table by shippingid and eventcode and timestamp.
Assuming no need for referential integrity, how will my performance
be affected if i had two indexes:
a. an index on shippingid,eventcode,date (in that order)
b. a bitmap on eventcode (since the unique values of eventcode are very
small( < 50) compared to the number of rows in the table (a mil. plus))
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat May 08 1999 - 11:57:39 CDT