[buddypress-trac] [BuddyPress Trac] #7460: Remove unwanted code for `Index hint`

[buddypress-trac]

#7460: Remove unwanted code for `Index hint`
----------------------------+-----------------------------
 Reporter:  vishalkakadiya  |      Owner:
     Type:  defect (bug)    |     Status:  new
 Priority:  normal          |  Milestone:  Awaiting Review
Component:  Activity        |    Version:  2.8.0
 Severity:  normal          |   Keywords:  has-patch
----------------------------+-----------------------------
 Some code was added for '''USE INDEX''' in buddypress 1.6.0, check on
 https://buddypress.trac.wordpress.org/attachment/ticket/4045/4045.02.diff

 Then it was decided that not need to use '''USE INDEX''' for several
 reasons, please check that on
 https://buddypress.trac.wordpress.org/ticket/5448

 After '''5448''' ticket '''USE INDEX''' was removed from the query but the
 other code which is added for that '''$index_hint_sql''' is not removed,
 please check that on
 https://github.com/buddypress/BuddyPress/commit/635e817f89e23e1f6459b7823647c7d13d95a267

 I am removing that unwanted code and adding my patch.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/7460>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac