What is the best table structure that you can use to gain optimal performance?

In one of your online transaction processing (OLTP) applications, most users frequently modify the
values, including the key values, of the application tables. Some users generate application
reports by using multiple application tables. What is the best table structure that you can use to
gain optimal performance?

In one of your online transaction processing (OLTP) applications, most users frequently modify the
values, including the key values, of the application tables. Some users generate application
reports by using multiple application tables. What is the best table structure that you can use to
gain optimal performance?

A.
Heap table

B.
Object table

C.
External table

D.
Clustered table

E.
Global temporary table

F.
Index-organized table (IOT)



Leave a Reply 0

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