# How to force an index in a SQL query?

**URL:** <https://discourse.laminas.dev/t/how-to-force-an-index-in-a-sql-query/3109>\
**Category:** Components & MVC\
**Tags:** laminas-db\
**Created:** [November 17, 2022, 2:59pm UTC](https://discourse.laminas.dev/t/how-to-force-an-index-in-a-sql-query/3109 "2022-11-17T14:59:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fabian\_Rahm](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/fabian_rahm/32/585_2.png) [@Fabian\_Rahm](https://discourse.laminas.dev/u/Fabian_Rahm)\
**Post date:** [November 17, 2022, 2:59pm UTC](https://discourse.laminas.dev/t/how-to-force-an-index-in-a-sql-query/3109/1 "2022-11-17T14:59:24Z")

</div>

I try to speed up some SQL queries and would love to add a “FORCE INDEX (indexName)” into a query while using the TableGateway pattern - does laminas-db provide any method to do so without writing raw queries?

---

<div class="post-metadata">

**Author:** ![froschdesign](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/froschdesign/32/38_2.png) [@froschdesign](https://discourse.laminas.dev/u/froschdesign)\
**Post date:** [November 17, 2022, 3:04pm UTC](https://discourse.laminas.dev/t/how-to-force-an-index-in-a-sql-query/3109/2 "2022-11-17T15:04:52Z")

</div>

Take a look at expressions: [SQL Abstraction - laminas-db - Laminas Docs](https://docs.laminas.dev/laminas-db/sql/#columns)