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 *