We have no problems with that. I mean indexes are used even without hints, if they're suitable for a query. 
Maybe you can share your Phoenix version, query, index definition and exec plan ?

On Mon, Aug 19, 2019 at 12:46 PM you Zhuang <zhuangzixiaoyou@gmail.com> wrote:
Yeah, I mean no hint , use appropriate index automatically. I create a local index  and a query with corresponding index column filter in where clause. But the query doesn’t use index, with index hint it uses it.


--
Aleksandr Saraseka
DBA
380997600401
   asaraseka@eztexting.com    eztexting.com