4 Replies Latest reply on May 13, 2015 1:40 PM by Steven Hawkins

    Multiple access patterns

    Mark Addleman Master

      I have a table whose clients must supply one of two columns or both in a query.  I have created three access patterns for the three possibilities: column a or column b or columns a & b. The performance of the data source depends on which columns are pushed down.  Is there a way to hint the planner that certain access patterns have precedence over others?