For Oracle:

```sql
select /*+ index(table_name (column_having_index)) */ *
from   table_name
where  column_having_index="some value"; 
```