Index Sample Size

Posted Leave a commentPosted in Indexes, Oracle, Table stats

Recently i was asked a question, what would be the sample size percentage for indexes when tables stats are gathered with estimate percent of 5 and cascade set to true.My answer to it was 5 within a second.I had this believe that the sample size percentage for an index is same to the estimate_percent given […]

No stats after creating index

Posted 4 CommentsPosted in 10gR2, Oracle

Starting from 10gR2, i believe (as i haven’t worked much on 10gR1 version) Oracle started computing/gathering statisticsĀ  automatically when we create index. SQL> create table latitude (a number, b number); Table created. SQL> insert into latitude values (1,2); 1 row created. SQL> insert into latitude values (1,3); 1 row created. SQL> insert into latitude values […]