I forgot to ask:

for indexes, does the order of column matters?

For example I want to create an index of ID, SchoolID, on terms table.

Does the order of the column matter in the index?

Thanks,