What table organization is the best for this workload?

In one of your online transaction processing (OLTP) applications, table keys are frequently
updated and queries performed using many different operators.
In addition, reports are generated using complex joins with non-equality operators.
What table organization is the best for this workload?

In one of your online transaction processing (OLTP) applications, table keys are frequently
updated and queries performed using many different operators.
In addition, reports are generated using complex joins with non-equality operators.
What table organization is the best for this workload?

A.
heap table

B.
object table

C.
external table

D.
sorted hash clustered table

E.
global temporary table
F. hash clustered table



Leave a Reply 0

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