What must be done to convert a populated base table to a multidimensional clustering (MDC) table?
Which command(s) should be used to drop database partition 10 from a database named MYDB?
What statement regarding Asynchronous index cleanup (AIC) is correct?
If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?
Given the following output:Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?
A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUDITING were created as follows:The majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers that would populate the table in table space TS2 each time changes were made to the database were then defined and the database was put into production. At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but performance has gotten worse as the table has gotten larger. What should be done to improve query performance?
