I have an sObject say
student( ..., student_name text,favourite_teacher lookup,marks integer)
By the documentation , lookup fields (favourite_teacher) will be indexed by default. Is it possible to create a composite index like (favourite_teacher,marks) i.e., one field is lookup and another one is a normal field.
