Migrate the index segment to another tablespace

Migrate the index segment to another tablespace Inorder to increase the index full scan performance and reduce scan table time, I do migrate the index segment to another tablespace which block_size is 16 k, the original is 8 k. this operation can reduce the scan io for index and increase the speed for select operation. suppose the oracle default tablespace block_size is 8 k. steps of this event

[SQL] Configure the db_16k_cache_size: ALTER SYSTEM SET DB_16K_CACHE_SIZE = 2048 M; Create the 16 k tablespace: create tablespace clicindtbs datafile '+ data' SIZE 2048 m autoextend off uniform size 1 m segment space management auto; Rebuild the target index alter index index_name rebuild tablespace clicindtbs;

 

That is all.