what is the default index type that will be created for an oracle table ?
Primary key column of a table is by default indexed while creating a table.
meda Changed status to publish 07/03/2022
While creating a table on Oracle schema, B-tree index is the default index type that will be created for our primary and unique key constraints of columns of the underlying table. But for our foreign key columns, we have to create an index manually.
meda Edited answer 21/02/2022