Index are handled automatically by Sybase database to speed up the query and in short to optimize the query .But in certain scenarios and situation the user may need to force the index for handling the inaccurate results shown by optimizer. This concept of forcing of index is called as forcing an index concept in Sybase.

This can be done as below:

select s1.deptcode s1.deptname
from dept s1 (index inddep)
emp s2
where s2.depcode s2.depcode