Oracle Magazine, September/October 2017
DBA PERFORMANCE being executed against it And whats more the conversion partitions the indexes of the table appropriately Lets see how that works First create an unpartitioned table named ACCOUNTS and insert some rows into it ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 95 create table accounts acc_ no number acc_ type varchar2 1 state_ code varchar2 2 acc_ balance number last_ trans_ dt date insert into accounts values 1 S CT 2000 1 jul 2014 insert into accounts values 2 S NY 8000 01 jul 2016 Commit Now lets create four indexes on the table on different columns note that one of the indexes is unique create unique index pk_ acc on accounts acc_ no
You must have JavaScript enabled to view digital editions.