Which of the following is required for the DB2 optimizer to consider a – McqOptions

MCQOPTIONS

1.	Which of the following is required for the DB2 optimizer to consider a hash join strategy?
A.	Optimization level 1 or above
B.	Equijion predicates
C.	Registry variable DB_ANTIJOIN=YES
D.	SORTHEAP large enough to contain the tables being joined
Answer» C. Registry variable DB_ANTIJOIN=YES

Discussion

No Comment Found

Related MCQs

With database logging, where are transaction records first placed?
Which statement fragments a table as round robin?
Which of the following tools can be used to identify inefficient SQL statements without executing them?
Which statement correctly changes the next extent size?
which of the following represents a set of properties that guarantee that database transactions are processed reliably in computer science ?
Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?
Which of the following extenders allows data to be presented in a three dimensional format?
Which of the following commands will allow a Linux on iSeries administrator to quickly scan backup tapes for files saved via a tar command on a Linux system?
Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
Where is fragment information stored?