Indexing Eloquent

CanIndexQueries.php

<?php

namespace App\Rise\Traits;

trait CanIndexQueries
{
    
        /**
         *  Example 
         *   $properties = Property::indexRaw('USE INDEX (brand)')
         *      ->with('brand', 'information')->where('status', 'active')
         *     ->where('status', 'active')
         *     ->where('brand', $brandCode)
         *     ->orderBy('property_name')
         *     ->get();
         */
    
    public static function indexRaw($index_raw)
    {
        $model = new static();
        $model->setTable(\DB::raw($model->getTable() . ' ' . $index_raw));
        return $model;
    }
}