Caresoft Global interview question

Stored procedure in SQL Index in sql