2 Replies Latest reply on Aug 18, 2014 12:26 PM by Laury

    Forcing index read only when two tables are joined

    Laury


      Hi,

       

      Is it possible to improve response time and to use only an index scan when:

      - Two tables are joined

      - The columns involved in the join and in the SELECT are columns that make up the two indexes for both tables

      Having in mind that most of both the tables will need to be selected.

       

      Is it a preferable option instead of using a hash join?

      If yes, how can we force it through a hint?

       

      Thanks and Kind Regards.