As i am new to the hibernate and have less knowledge about it ...
So if anyone here know how to write the following query in HQL ...


The MYSQL query :-

select p.id from Pages p use index (seq_number_one) where p.scene_id = :sceneid and p.seq_Number > 0 order by p.seq_Number ;

My Current working HQL Query is :-

select p.id from Pages p where p.scene.id = :sceneId and p.seqNumber > 0 order by p.seqNumber


Here i am trying to use the database index and guide the Database optimizer to use the following query...

Did Hibernate support Database indexes in HQL Queries...


Thank's in Advance...