Level 102
What index? Can you show an example?
Nov 21, 2021
5
Level 1
Add ->index to the DB query builder
First, thanks for the fantastic framework.
I am thinking of using a specific index in the DB:: query builder and searching the options in the DB:: class but it seems that there is no ->index or ->useIndex in the options. Is there any way that I add it as an (optional) option to DB query builder?
Level 1
this is an example of raw query: DB::select("select name from users USE INDEX (names) limit 10");
and I would love to write it like DB::table('users')->select('name')->useIndex('names')->limit(10);
Level 102
@hameti ah yes I understand. Sadly it's not build in, but there is a package to add support
1 like
Level 1
@Sinnbeck Thanks a lot.
Level 102
@hameti happy to help
Please or to participate in this conversation.