In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?
A.
heap table with a primary key index
B.
external table
C.
hash clustered table
D.
global temporary table
E.
index clustered table