Oracle9i™ Development by Example

Implementing IOTs into Existing Applications

Several of the Sales Tracking table objects are good candidates for IOTs. A good candidate is a table with infrequent updates but frequent use of some of the columns. The ST_VENDOR table (see Listing 13.9), as well as the ST_CUSTOMER table, lends itself well to IOTs. Both tables have frequent read access with just the ID and names fields being frequently accessed. Notice the INCLUDING clause lists the vendor_name field. This field is frequently accessed by the ST_INVENTORY application when the vendor_id field is used to verify the accuracy of information entered onscreen.

Listing 13.9. ST_VENDOR Index-Organized Table

CREATE TABLE st_vendor (vendor_id NUMBER(6) PRIMARY KEY, vendor_name VARCHAR2(30) ...