12.2 Index Advanced Compression “High”.
12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a NOCOMPRESS index in the WHALE tablespace: SQL> create table WHALE (id number, Slno number, name varchar2(38));Table created. SQL> insert into WHALE select rownum, mod(rownum,10), ‘BLUE WHALE’ from dual connect by level <= 1000000;1000000 rows created. SQL> commit;Commit complete. SQL> create … Read more