Index not found error while using index hints

[sidhesh gawas]

Hi,

I am facing issue while using index hints in my select query.

  

Select * from MY_TABLE USE INDEX(MY_TABLE_INDEX) 
When i fire a normal select query with out the hints works fine, but with the index hints it throws an error saying index not found.
nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Index \" MY_TABLE_INDEX  \" not found;

I have check the INFORMATION_SCHEMA.INDEXES on my table and the index is present.
Can someone please help me

Thanks,
Sidhesh

[Evgenij Ryazanov]

Hi!

I think there are only two possible reasons for that failure.

1. Index belongs to another table (possibly with the same name, but in different schema).

2. Index has another name, for example, "my_table_index" (quoted identifiers are case sensitive by default).