Which table organization or type would provide the best…

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?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *