Home » Oracle » 1z0-591 » How can you optimize the way the BI Server processes the query?
A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?
A. By specifying a one-to-many join between the tables with the small and large numbers of values
B. By specifying a driving table
C. By specifying a many to one join between the tables with the small and large numbers of values
D. By creating your logical join by using the Joins Manager
E. By creating your joins by using the Business Model Diagram
Correct Answer: B
Explanation/Reference:
You can specify a Driving table parameter in a complex join.
Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross-database joins when one table is very small and the other table is very large.
The BI Server will query the driving table (the small one) and will get a list of values. The BI Server will then generate a second SQL using a parameterized IN list with the values from the first query.
Specifying driving tables leads to query optimization only when the number of rows being selected from the driving table is much smaller than the number of rows in the table to which it is being joined.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
