When would bind peeking be done for queries that vary only in values used in the WHERE clause?
A. When the column used in the WHERE clause has evenly distributed data and histogram exists on that column.
B. When the column used in the WHERE clause has evenly distributed data and index exists on that column.
C. When the column used in the WHERE clause has non uniform distribution of data, uses a bind variable, and no histogram exists for the column.
D. When the column used in the WHERE clause has non uniform distribution of data and histogram exists for the column.
|
Download Printable PDF. VALID exam to help you PASS. |
 |