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 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/b4db24c8-21c2-4924-8693-7fc23bb4978bn%40googlegroups.com.
