You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance deg
Posted: Sun Jun 11, 2023 3:49 pm
You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database.View the Exhibit named TOP5EVENTS and note the top five events.View the Exhibit named TOPSQL and note the problems related to these statements.View the Exhibit named INSTACT and note the table scans.Which is the most appropriate solution?
A. Create indexes on short tables.
B. Use the CACHE hint to access long tables.
C. Keep the long tables in the keep buffer pool.
D. Keep the short tables in the keep buffer pool. E. Keep the short tables in the recycle buffer pool.
- You Are Working 1 (104.64 KiB) Viewed 266 times
- You Are Working 2 (330.78 KiB) Viewed 266 times
- You Are Working 3 (163.02 KiB) Viewed 266 times
B. Use the CACHE hint to access long tables.
C. Keep the long tables in the keep buffer pool.
D. Keep the short tables in the keep buffer pool. E. Keep the short tables in the recycle buffer pool.