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