Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)
Poorly tuned memory can affect application performance, such as having sequential prefetch turned off. Which statistic should you monitor from the statistics report to be sure this is not occurring?
In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?
The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the NEWBILL work runs under a single plan, NEWBILLPL. What STARTTRACE command should be used to gather the I/O information needed for the objects in database NEWBILL?
When is a merge scan join a well performing access path?
