GregMark

 Profile Answers by GregMark Questions by GregMark

• May 5th, 2007

 

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