Test case when index size can grow than table size and effect of rebuild index
Test case preparation I am going to create test case to simulate different index test cases Test case 1:-First we create procedure to parallel insert in 10 sessions.The insert query will insert data based on random values generated from select query.Please note I will run gather stats after every test case. SQL>create table t(id number,sometext varchar2(50),mydate date); […]