0

I'm using the ZF2 table gateway for a database select with following join:

$select->join('feedback'
    , new Expression('feedback_id = feedbackcar_feedback_id')
    , ['provider_foreign_id' => 'feedback_action_provider_foreign_id']
    , Select::JOIN_INNER);

How can I add "USE INDEX (idx_actionforeignid_productid_providerrecommend)"?

Is there any way?

johnny 5
  • 19,893
  • 50
  • 121
  • 195
KiwiJuicer
  • 1,952
  • 14
  • 28

1 Answers1

1

Zend\Db\Sql\Select is not flexible enough to avail such a feat. You will be better off with a manually written sql query.

akond
  • 15,865
  • 4
  • 35
  • 55