First page Back Continue Last page Graphics

Indexes Part 3 Workshop: Bitmap Join Index


Notes:

Bitmap Join Index Workshop
Create a bitmap join index called CUST_ORD_BJIX on the ORD table. The key of this index should be the CITY column in the CUSTOMER table.
Query the USER_INDEXES, USER_IND_COLUMNS, and the USER_JOIN_IND_COLUMNS views to display information related to the bitmap index that you created in question 1.
Query the USER_INDEXES, USER_IND_COLUMNS, and the USER_JOIN_IND_COLUMNS views to display information related to the bitmap index that you created in question 1.