Varchar2 – update will use more extents
PK and unique key in Oracle will create index
Index
non unique
allow insert duplicate pk
commit ← check constraint, rollback
truncate table – DDL no rollback
bitmap index
sequence – cache default next 20 values
No comments:
Post a Comment