Create two indexes for one single table
create table indextest as
select * from dba_objects where owner in ('OUTLN','PUBLIC','SCOTT','SYS','SYSTEM');
create index indxtest_objname_idx on indextest (object_name) pctfree 10;
create index indxtest_objname_fidx on indextest(upper(object_name));
select object_name,owner from indextest
where upper(object_name) ='DBA_INDEXES';
select upper(object_name) from indextest;
alter table indextest modify object_name NOT NULL;
select upper(object_name) from indextest;
drop table indextest;
Related examples in the same category