案例四

点击(此处)折叠或打开

--删除customers表上的所有索引
sh@TESTDB11>@drop_customers_indexes.sql
--在customers表上创建3个不同的位图索引, 并查看
sh@TESTDB11>CREATE BITMAP INDEX bidx_cust_gender ON customers(cust_gender) NOLOGGING COMPUTE STATISTICS;
sh@TESTDB11>CREATE BITMAP INDEX bidx_cust_postal_code ON customers(cust_postal_code) NOLOGGING COMPUTE STATISTICS;
sh@TESTDB11>CREATE BITMAP INDEX bidx_cust_credit_limit ON customers(cust_credit_limit) NOLOGGING COMPUTE STATISTICS;
SELECT ui.table_name, DECODE(ui.index_type, \'NORMAL\', ui.uniqueness, ui.index_type) AS index_type,
ui.index_name
FROM user_indexes ui WHERE ui.table_name = \'CUSTOMERS\'
ORDER BY ui.table_name, ui.uniqueness DESC;

点击(此处)折叠或打开

ITPub博客

课程实践（二）续