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 […]

DBA_INDEXES shows no index but Create Index errors out with ORA-01408: such column list already indexed

Posted Leave a commentPosted in Indexes, Oracle, RAC

Yesterday we had a very interesting issue popped up on 10.2.0.5 database where the team running a sql script got “ORA-01408: such column list already indexed” though the dba_indexes showed no index on the table.The index to be created was “test_u1” 23:11:01 [email protected] > @index Enter value for owner: anand Enter value for table_name: TEST […]