Using Index hint in oracle database

If running from different schema you need to use alias table name.

In the below example i used temp

select /*+index(temp temp_idx_01) */ * from hma_tm_prod.ddx temp where vin like '%123454';


If running from same schema then we can you table name directly.

select /*+index(ddx temp_idx_01) */ * from ddx where vin like '%123454';